MDX: How To Aggregate Hierarchy Level Members With Same Name
- by Dave Frautnick
Greetings,
I am new to MDX, and am having trouble understanding how to perform an aggregation on a hierarchy level with members that have the same names. This query is particular to Microsoft Analysis Services 2000 cubes.
I have a given hierarchy dimension with levels defined as follows:
[Segment].[Flow].[Segment Week]
Within the [Segment…