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.
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:
Click on the option menu for the Sales Date dimension:
Then select Create a time hierarchy....
SAP Lumira will create new date dimensions as follows: