user2857783
Reputation: 1
Is it possible to define a calculated member in MDX (ex. Percent of Total) without specific dimension/hierarchy?
Is it possible to define a calculated member in MDX (ex. Percent of Total) without specific dimension/hierarchy? I'm wondering if there's an easier way to get the percent of total of several dimensions without defining a calculated measure for each.
Upvotes: 0
Views: 172
Answers (1)
FrankPl
Reputation: 13315
This is not easy. One approach is described here: http://tomislav.piasevoli.com/2009/10/25/bitmap-index-universal-percentage-in-owc-take-2/
Upvotes: 0
Related Questions
- Define a calculated member in MDX by filtering a measure's value
- MDX Calculated Dimension Member base on another dimension
- MDX expression where dimension members become column totals
- MDX Calculated Members with Named Set
- How to make a calculated member in MDX for SSAS?
- In MDX, how can I perform a calculation on the child members and THEN aggregate those children?
- SSAS CUBE Calculated member based on different members in dimension and different measures
- How do I define a Calculated Measure in MDX based on a Dimension Attribute?
- MDX for Percent of Total for a subset of a Hierarchy
- Get share of dimension member in calculated measure