Hyperion Essbase Knowledgebase

Essbase Excel Tips Miscellaneous

  • Print
User Rating:  / 0

Goal: attempting to find the level 0 members with the greatest number of generations. 

Steps:in excel, native addin, performed zoom in bottom level, indention turned on for sub items.  Then the formula:

=find(left(trim(a3)),a3)-1 will return the number of spaces preceeding the member label.  The largest number indicates the member that has the greatest number of generations above it.  It looks like for each indention, Essbase places 5 spaces.

I wanted to get this quick and not have to crack open the api.  Smartview has some interesting query abilities with basic VBA from inside excel but I couldn't find anything that returned a level or generation number.