This is part of the SAP Lumira Discovery blog series.

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

SAP Lumira Discovery supports most of the hierarchies from SAP HANA and BW. But there have been multiple scenarios in which the business users would want to build their own hierarchies or try customizations. So how would we leverage SAP Lumira Discovery in these scenarios?

SAP Lumira Discovery supports 3 types of hierarchies,

  1. Date/Time: Year – Quarter – Month – Date / Hour – Minute – Seconds
  2. Geographical: Region based : Country – State – City / Lat and Long
  3. Custom: define your own hierarchy

 

1. Date and Time Hierarchies

 
SAP Lumira Discovery is smart enough to detect date (calendar icon) and time (clock icon) fields in the design view. But the date field alone would not be sufficient to perform trend analysis. Instead, we would need an option to drill through different levels like Year-Quarter-Month-Day. The Date/Time hierarchy provides this functionality with one-click.

We can find this option by right clicking the appropriate dimension as shown below,

 

Building Hierarchies in SAP Lumira Discovery - 1
 
On click, the hierarchy is generated automatically and can be found on top of the dimension list as shown below,
 
Building Hierarchies in SAP Lumira Discovery - 2
 
This hierarchy can then be leveraged into the visualizations for trend based analysis. SAP Lumira Discovery can also be used to implement fiscal year hierarchies and date hierarchies with only two dimensions (year and quarter).
 

2. Geo Hierarchies

 
SAP Lumira Discovery also allows you to leverage data for geospatial analysis. This helps us in performing location based analytics on a geo map with the ability to drill through different levels of granularity.

We can find this option by right clicking the appropriate dimension as shown below,

 

Building Hierarchies in SAP Lumira Discovery - 3
 
There are two options to create a geo hierarchy,

Using Names: We define Country – Region – Sub-Region – City levels using appropriate dimensions and SAP Lumira Discovery maps it using the NAVTEQ database (part of the in-memory velocity engine).
 
Building Hierarchies in SAP Lumira Discovery - 4
 
We would then need to complete the mapping of the locations to finalize the hierarchy.
 
Building Hierarchies in SAP Lumira Discovery - 5
 
NOTE : NAVTEQ has a limitation of displaying only cities with population above 100k.
 
Building Hierarchies in SAP Lumira Discovery - 6
 
How would you go about handling this limitation?

Using Latitude and Longitude: The above limitation can be overcome by using latitude and longitude values with the corresponding dimension.

 
Building Hierarchies in SAP Lumira Discovery - 7
 

3. Custom Hierarchies

 
Apart from Geo and Date/Time, SAP Lumira Discovery can also create hierarchies on set of dimensions based on customization.

Example : Product Category > Product Sub-Category > Product Type

Right- click on a dimension and select Hierarchy -> Custom.

 

Building Hierarchies in SAP Lumira Discovery - 8
 
Create Hierarchy window pops up. Select the dimensions on which you want to create the hierarchy. Selection should be made in correct order and then click on Create.
 
Building Hierarchies in SAP Lumira Discovery - 9
 
The hierarchy is created and listed in the dimensions’ list.
 
Building Hierarchies in SAP Lumira Discovery - 10
 
NOTE : Hierarchies once created can only be renamed or deleted, you would not be able to edit them. Since the process is simple and fast, we can do a quick rebuild. If the dimension is numeric we can also leverage them in a date hierarchy and if a character then in a geo hierarchy.

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