Level of hierarchy, Dynamic Cubes as source

[Deep750]

Hi,
I have prevously used the function

Code Select Expand

ordinal(level(currentMember(<HIERARCHY>))) for finding the level in a hierarchy when drilling, and the source has been Transformer cube or DMR.

I'm trying to get the same info, but now I have Dynamics Cube as source. When I use the function, it doesn't return any values in cross tab - added as a column. If I add it to a list-report, it does work.

Does anyone know how to get it to work?

[MFGF]

Hi,
I have prevously used the function

Code Select Expand

ordinal(level(currentMember(<HIERARCHY>))) for finding the level in a hierarchy when drilling, and the source has been Transformer cube or DMR.

I'm trying to get the same info, but now I have Dynamics Cube as source. When I use the function, it doesn't return any values in cross tab - added as a column. If I add it to a list-report, it does work.

Does anyone know how to get it to work?

I suspect the difference here is that previously you were using CQM (Compatible query mode) but with your Dynamic Cube you are now using DQM (Dynamic Query Mode). I suspect the expression will still return the desired level number under the covers, but your crosstab will baulk at displaying it since it isn't a member or a set of members or even an attribute of a member. If you're just using it to derive something else that is member-based, it will probably be ok (although you're not going to be able to display the level number easily within the crosstab).

Cheers!

MF.

[Deep750]

Thank you for your answer.
I managed to get it to display, by unlocking the work space, and adding the item within the row-column.

So yes, it works under cover :)