Enriching data

SAP Lumira offers you various methods to enrich your dataset by adding measures, geography hierarchies, and time hierarchies. Measures allow you to easily manipulate calculations, and hierarchies allow you to use a natural grouping of related columns.

SAP Lumira detects columns that are potential measures, time hierarchies, and geography hierarchies when we acquire data.

The time hierarchy

By default, we have only Sales Date, but for a detailed historical analysis, we need to analyze various date dimensions, such as year, month, week, and so on.

Let's create the time hierarchy for Sales Date with the following steps:

1. Click on the option menu for the Sales Date dimension:

   

2. Then select Create a time hierarchy....

3. SAP Lumira will create new date dimensions as follows:

   

The geographical hierarchy

Modern analytics tools provide us with the opportunity to look at data from the geographical perspective. It gives us lots of advantages: for example, we can easily measure the region that is the...