I am trying to define a Calculated Member such as:
WITH MEMBER [Sales].[Sales Member] AS
The problem is that when I am trying to do something like this in MDX:
[Sales].[Sales Member] ON 0,
[Location].[Hierarchy].Members ON 1
I get a result that looks like a CrossJoin() between the sum of the intersection of the measure on the given Date, and every Member of the Location Hierarchy. Feels like I am missing something very important in terms of interacting with Hierarchies
via MDX. How could I go about implementing said Calculated Member? I would also love to hear a basic explanation, of the principle if that's not entirely too much to ask for.
View Complete Post