Skip to Content

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,

/wp-content/uploads/2016/05/1_948734.png

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,

/wp-content/uploads/2016/05/1_948734.png

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.

/wp-content/uploads/2016/05/1_948734.png

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

/wp-content/uploads/2016/05/1_948734.png

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

/wp-content/uploads/2016/05/1_948734.png

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,

/wp-content/uploads/2016/05/1_948734.png

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

/wp-content/uploads/2016/05/1_948734.png

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

 

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. krishna kotha

    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

    Thanks

    Krishna

    (0) 
    1. Varun Anand 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

      (0) 

Leave a Reply