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? |