Custom aggregation -
10-27-2006
, 08:54 AM
Just a warning - I'm fairly new to SSAS.
I'm working on a reporting solution for assessments for a school system,
based on SSAS 2005. I have a hierarchy of Assessment->Level1->Level2, and an
assessment that includes scores for various areas (ie, English, Math, Social
Studies) as well as overall scores that are not aggregates of the area
scores. The overall scores would map to Level1 and the area scores to
Level2. All scores are from the same table and field.
Right now, I have all levels in the hierarchy returning an average
aggregate. SSAS is pushing the score associated with Level1 (overall score)
into Level2 and aggregating it along with the area scores to obtain the value
for Level1.
I need to get the average of only the area scores for Level2, and the
average of the overall scores for Level1 and levels above it. How do I do
this?
I hope this makes sense. Thanks in advance for you help. |