Re: How To Structure?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rick (bob_at_bob.net)
Date: 04/01/04 

Date: Thu, 1 Apr 2004 14:49:09 -0600

Can you expand on this? I can't visualize it. I was thinking of a
parent-child dimension for the unbalanced nature. Does that make sense?

"Tom Chester" <nospam_public@tomchester.net> wrote in message
news:VvZac.89$D12.31307@news.uswest.net...
> I don't know what "strand" is, but in the abstract you might consider a
> normalized design where rather than having columns in the fact table for
> Strand0 - Strand10, instead have a StrandNo column and use it as the basis
> for a Strand dimension.
>
> public @ the domain below
> www.tomchester.net
>
> "Rick" <bob@bob.net> wrote in message
> news:106ofbd803o6c59@corp.supernews.com...
> > We would like to analyze student test score data as well as strand score
> > data.
> > Sample data may look like this:
> >
> > Math Test Raw Score: 1590 (Test)
> > Shapes: 250 (Strand)
> > Spaces: 185 (Strand)
> > Measurements: 284 (Strand)
> >
> > Problem: There is a random number of strands between zero and ten. We
are
> > wondering how to model this process. Is there a way to analyze this
> > information in one fact table so that we can see score and strand
> > information?
> >
> > sample_fact_table (horizontal)
> > ----------------------------------
> > raw_score | strand_1 | strand_2 | strand_[n]
> > 1590 | 250 | 185 | 284
> >
> > sample_fact_table (vertical)
> > ----------------------------------
> > raw_score
> > 1590
> > 250
> > 185
> > 285
> >
> >
> >
> >
> >
>
>