This is part of the SAP Lumira Discovery blog series.

Hierarchies play a big role in data analysis and ease of navigation. We have covered in earlier blogs the different kinds of hierarchies that SAP Lumira Discovery supports and best practices in building them. Unlike the previous version, the new cross tab and charts in SAP Lumira Discovery comes with robust drilldown and interaction capabilities. Following functionalities can be achieved using hierarchies:

  1. Drill up – Helps you drill a level up the hierarchy
  2. Drill down – Helps you drill a level down the hierarchy
  3. Drill by – Similar to drill down operation. The only difference is that it displays the initial level along with the one below.
  4. Drill path – It helps choose the drilldown path in case the dimensions have more than one hierarchy drilldown paths

Let’s consider an example with 3 levels (category -> sub-category -> name) of Product hierarchy. The image shows all drill options that can be leveraged using a detailed cross tab,
 
Navigate through Hierarchy is SAP Lumira Discovery - 1
 

1. Drill Up

This functionality is leveraged when trying to move to the above level of the hierarchy. The above example of a custom hierarchy that has been drilled up to the highest level, showing Product Category and Sales value.
 
Navigate through Hierarchy is SAP Lumira Discovery - 2
 
Navigate through Hierarchy is SAP Lumira Discovery - 3
 
An example of a date hierarchy before applying Drill Up, showing both Year and Quarter.
 
Navigate through Hierarchy is SAP Lumira Discovery - 4
 

2. Drill Down

The functionality is leveraged to go levels below the hierarchy without showing the above levels. The custom hierarchy after the Drill Down, where the analysis is done at the Product Sub-Category level but the filter is applied at the Product Category level.
 
Navigate through Hierarchy is SAP Lumira Discovery - 5
 
Navigate through Hierarchy is SAP Lumira Discovery - 6
 

3. Drill By

 
The functionality is leveraged to go levels below the hierarchy while also showing the levels above. The custom hierarchy after the Drill By, where the analysis is done at the Product Sub-Category and Product Category level.
 
Navigate through Hierarchy is SAP Lumira Discovery - 7
 
The line chart to the lowest level of the date hierarchy using Drill By option, where we can see the Year, Quarters and Months
 
Navigate through Hierarchy is SAP Lumira Discovery - 8
 
This information is based on the current product and roadmap and is bound to change.

Interested to learn how to leverage SAP Lumira for your enterprise (or) train your business users in SAP Lumira Discovery? Reach out to us today.

Subscribe to our Newsletter

5920 Windhaven Pkwy
Plano TX 75093.

+1 888-227-2794

+1 972-232-2233

+1 888-227-7192

solutions@visualbi.com