dbTalk Databases Forums  

Parent/Child Dimension, Non-Leaf Level has data but should only roll-up to parent

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


Discuss Parent/Child Dimension, Non-Leaf Level has data but should only roll-up to parent in the microsoft.public.sqlserver.olap forum.



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

Default Parent/Child Dimension, Non-Leaf Level has data but should only roll-up to parent - 06-16-2005 , 10:37 AM






I am working on a survey application. I have a Manager Hierarchy where
managers will view their survey results for their organization. This
is a Parent/Child Dimension. The managers are also taking the surveys.
Their results should only be included in their managers' results.

In other words the (Smith, Joe Data) row under the Smith,Joe hierarchy
needs to be ignored in the rollup totals.
+ Edmunds, Alan
- Evans, Dave
...
- Smith,Joe
Adams, Frank
Cook, Sally
+ Glass, Nancy
Hewson, Paul
(Smith, Joe Data)

Is this a Custom Rollup formula? Do I have to do something in MDX?


Reply With Quote
  #2  
Old   
Lesley
 
Posts: n/a

Default Re: Parent/Child Dimension, Non-Leaf Level has data but should only roll-up to parent - 06-24-2005 , 07:38 AM






Deepak helped me with this one. Added custom rollup on my hierarchy:
CalculationPassValue([Measures].CurrentMember,
-1, RELATIVE) -
iif(IsLeaf([Hist Mgr Hierarchy Dim].CurrentMember),
0,
CalculationPassValue(([Measures].CurrentMember,
[Hist Mgr Hierarchy Dim].CurrentMember.DataMember),-1, RELATIVE))


Thanks Deepak! You are an MVP!!!!


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.