MDX code for Dimension to affect only certain measures

[davidagnew37]

Is it possible to write MDX code for a Dimension (in the "All member formula"??) which will specify that only certain measures are affected by that dimension - say measures A,B and not C for example.

This is becuase I have 3 measures "Actual", "Budget", "Full Year Budget" and I have a dimension called "Time" - which I only want to effect measures "Actual", "Budget" AND NOT "Full Year Budget".

 

[MDXer]

The best way to achive this would be to create to seperate cubes with the appropriate dimensions and measures that you want. THen bring these 2 cubes together in a virtual that includes all dimensions and measures. Since the dimensional relationship is established in the physical cube measure in the virtual will not be affected by dimensions that do not exist within it's physical cube structure.

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

 

[davidagnew37]

I have tired this with little success...unfortunately the measures affect those measures from the "other" cube. I thought MDX would be the best way forward?

 

[MDXer]

The reason MDX won't work is that and dimension not explicity refferenced in a query is automatically figured at the all level.

you may look at using calculated cells. without a solid object to work with it is difficult to play around and try to find an answer. If I have time over the weekend I'll see what I can work out.



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