Hi,
I have prevously used the function 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?
Quote from: Deep750 on 13 Mar 2015 06:28:09 AM
Hi,
I have prevously used the function 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.
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 :)