Hello All

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
subsection scores.
A schematic:
Score
Subject 600
Section1 60
Subsection11 50
Subsection12 40
Section2 20
Subsection21 10
Subsection22 10
Subsection23 40
Section3 80
In essence the Subject dimension is ragged. I used the hideif (no
name) to get the dimension to look like it is not "ragged".

Problem:
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
=50 etc
The scores get rolled up (summed) at the All level instead of showing
600.

Any help would be greatly appreciated.