Skip to Content
Author's profile photo Varun Anand

Leveraging Custom Hierarchies in Lumira 1.31

Hierarchy is an arrangement of items (objects, names, values, categories, etc.) in which the items are represented as being “above,” “below,” or “at the same level as” one another – Wikipedia


There have been multiple scenarios in which the business users would want to build their own hierarchies or would benefit from grouping values and then using it in a hierarchy. Lumira has the ability to build Custom Hierarchies on the fly and is pretty simple to learn.


Custom Hierarchy can be built from the Prepare/Visualize room  as shown below,


Best practice would be to finish all the data manipulation in the Prepare room itself.


Go ahead and define the Hierarchy and make the changes required as shown below,


Once the Hierarchy is created, it cannot be modified. So care needs to be taken to define the order, else you would just need to remove it and define a new one.


This new Hierarchy can be consumed directly into the Visualize tab for performing analysis.


We can now navigate by Drill Up/Down options to move across the Hierarchy.


This would enable us to identify outliers and make other decisions easily.


Navigation is also possible back by Drill Up or by modifying the Filter condition.


We can use Custom Hierarchies in different charts. Below is an example of using it in a Crosstab,


We can drill down to find the sum of each sub-category as well by leveraging the hierarchy,


Please note that I have applied filter conditions as well.


This shows how easy it is to build and use Custom Hierarchies to dramatically increase the efficiency of your analysis as compared to seeing only rows and columns in an spreadsheet.


For a step-by-step instruction to build and use Custom Hierarchy, please refer to the link Create a custom hierarchy: SAP Lumira 1.28 – YouTube


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Glad you provided detailed information on hierarchies, I had been searching for a detailed information on this topics. Quick question Varun, why hierarchies are disabled in some places, for instance in HANA online view. Is this going to be a future provision



      Author's profile photo Varun Anand
      Varun Anand
      Blog Post Author

      Hi Krishna,

      Thank you for the comments. HANA online is a special case, where majority of the data preparation is expected to be done in the back end system itself. This is to maintain efficiency of the live data connectivity with HANA.

      Thank you,

      Varun Anand