Generically Specifying a Dimenions

[micol]

Is there any way in MDX to specify a dimension without actually naming it?

For example I want to calculate a distribution of all members to the total of each dimension but I can't figure out a way of doing it in only one calculation.

e.g.

[Measures].[Part Of Day]/(Ancestor([Time Groups].[Standard].CurrentMember,[Time Groups].[Standard].Levels(0)),[Measures].[No Of Employees])

This will calculate the distribution for the measure 'Part of Day' for the Times Groups.Standard dimension but will not calculate it for any other dimension.

 

[justins57]

micol,

You might try using the validmeasure() function. I know this works on virtual cubes, but not sure if it will work in your case.

Justin