Different measures for different levels

[dssd]

In a MDX Report, can we have different measures for different levels, as in have on measure at level 1 and when we drill down to another level have another measure show up

[Bark]

Hi asdf,

It could be done but is not as easy at it might seem. You would need to create a dataItem in the report with an IF statement evaluating the Level of the currentMember. The funny thing comes with the drill-down, I don't think the standard definition will work (I haven't try it) but I bet you will need to allow the data item to create membersets and alter the default drill down behaviour to "Replace MemberSet".

Let me know if with this information is enough and you can work it out on your own, otherwise, I would try to mock something up.

Regards,

Bark

[dssd]

Thanks. Is it possible to identify the level of the current member? If you could mock it up and let me know tht would be great. I am a bit new to MDX. Thanks again

[CognosPaul]

Bark, the standard drill down functionality will work perfectly with this. It will also work fine with sets containing multiple levels. The only issue will be calculated members, like totals. I'm not entirely sure how that will work.

asdf, you can use roleValue('_levelNumber',[Data Item]) or roleValue('_levelNumber',currentMember([Cube].[Dim.].[Hier])). The measure data item should look something like: if(roleValue('_levelNumber',[Data Item]) = 1) then ([Measure 1]) else (if (roleValue('_levelNumber',[Data Item])) = 2 then ([Measure 2]) else([Measure 3]))

[Bark]

Thanks for the clarification PaulM. Good to hear it works with the standard config, otherwise it would overcomplicate things.

About the Level, I am pretty sure there is a function for that. I have no way to access RS right now but if you go to the function pane in the expression editor you'll probably find it under multidimensional functions -> L.

Regards,

Bark