dbTalk Databases Forums  

Custom aggregation

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Custom aggregation in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
KDM
 
Posts: n/a

Default 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.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.