I would like to know if there is a way to determine against a SSAS 2008 OLAP cube the lowest populated level in a hierarchy which is a ragged hierarchy. I can use the following...
ordinal(level(item(tail(hierarchize(members([sales_and_marketing].[Products].[Products]))),0)))+1
...to determine the last level position but I really want to navigate to the level which is populated.
Regards L
roleValue(
'_levelNumber'
, item(
order(
filter(
[Cube].[Dim].[Hierarchy]
, [Cube].[Measures].[Measure]>0)
, roleValue('_levelNumber',currentMember([Cube].[Dim].[Hierarchy]))
, bdesc)
, 0)
)