Unbalanced dimension problems - 08-28-2004 , 08:28 PM
My problem is this:
I am trying to use MS Analysis services to analyze whether height of
students impacts student scores on an aptitude test. Student height is
one measure and the others are student_id and score on test. I intend
to use the student_id in a count rollup and perform average height and
test score calculations.
The test has different sections with scores. Each section in turn has
subsections with their scores. Section scores are not the summation of
In essence the Subject dimension is ragged. I used the hideif (no
name) to get the dimension to look like it is not "ragged".
How do I get analysis services to show (using example above) at the
subject level that subject score = 600
and upon drilling down that Section1 score = 60, Subsection11 score
The scores get rolled up (summed) at the All level instead of showing
Any help would be greatly appreciated.