How can I create a measures hierarchy?

[BKhanna]

I am trying to create a hierarchical structure for measures, which Analysis Services doesn't allow. Is there any way to do this? Example: Cost1, Cost2 and Cost3 rollup to Cost which rolls up to Expenses. I know I can create calculated measures, but some of the children do not add up to the parent measure, which only exists as a navigational aid.

Thanks for your feedback!

 

[MDXer]

You can't create a measure hierarchy, but you can use calculated cells rather than a calculated member (measure). THe calculated cell will allow you to apply boolean logic to determine how or if to executed the calculation. you could do something like

IIf Measure.CurrentMember = "Expenses"

Measure.Cost1 + Measure.Cost3

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[justins57]

I'm not sure I understand what you mean when you say they don't add up to the parent measure. If you can illustrate with an example, we may be able to help you.

Topics to research:

AddCalculatedMembers()
VisualTotals()

 

[BKhanna]

Here is an example:

Measures
~ KioskStatsPartition
~ Kiosk_Session_Stats
~ Kiosk_Baggage_Stats
~ Number_Bags_Checked
~ Number_Bags_Checked_Not_at_Kiosk
~ Kiosk_CheckIn_Stats

Since we have almost 300 measures, it is hard for the users to find what they need, so in our current Essbase application, we have the measures grouped under parent levels for ease of navigation, but the children do not necessarily add up to the parent (shown by the tilde ~ in the example).

Thanks again!

 

[MDXer]

Analysis Services Doesn't Support a Measures Hierarchy like ESSBase does.

Again Calculated Cells will handle the Rollup issues as for grouping the measures I am uncertain how to accomplish that

Shoot Me! Shoot Me NOW!!!
- Daffy Duck