|
Home > Archive > MS SQL Server OLAP > June 2005 > Parent/Child Dimension, Non-Leaf Level has data but should only roll-up to parent
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Parent/Child Dimension, Non-Leaf Level has data but should only roll-up to parent
|
|
| Lesley 2005-06-16, 11:24 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?
| |
| Lesley 2005-06-24, 7:23 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!!!!
|
|
|
|
|