If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Dynamically determine lowest populated level in ragged hierarchy

Started by LDJB81, 25 Jul 2013 08:42:22 AM

Previous topic - Next topic

LDJB81

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


CognosPaul

roleValue(
  '_levelNumber'
  , item(
    order(
      filter(
        [Cube].[Dim].[Hierarchy]
        , [Cube].[Measures].[Measure]>0)
      , roleValue('_levelNumber',currentMember([Cube].[Dim].[Hierarchy]))
      , bdesc)
    , 0)
)