Generate Time Table and Dimensions
Create time tables and dimensions in SAP Datasphere which then allows you to gather insights with year, quarter, month and day granularities.
You will learn
- How to create time tables and dimensions
- How to associate the time dimensions with your data
Prerequisites
- Have at least one graphical view created and deployed in SAP Datasphere – see Model Data with a Graphical View.
- Have a date field in your dataset or views to be analyzed
Let’s suppose you have two columns named Product
and Createdat
with the values of 'product_x'
and '20210707'
in your dataset or view.
You can easily associate the Createdat
field with the time dimensions in SAP Datasphere to get '20210707'
and year, quarter, month and day columns for the Product_x
additionally.
You can then for example visualize the sales of Product_x
throughout the year 2021 to see the months, days, quarter wise analysis.