Generate Time Table and Dimensions
- How to create time tables and dimensions
- How to associate the time dimensions with your data
- Have at least one graphical view created and deployed in SAP Data Warehouse Cloud – 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
Createdat with the values of
'20210707' in your dataset or view.
You can easily associate the
Createdat field with the time dimensions in SAP Data Warehouse Cloud to get
'20210707' and year, quarter, month and day columns for the
You can then for example visualize the sales of
Product_x throughout the year 2021 to see the months, days, quarter wise analysis.
- Step 1
Go to the space management icon in the SAP Data Warehouse Cloud and navigate to the time data area or click on the time data tab.
Click on Create timetables and dimensions.
In the next dialog, you can configure your time table. You can give a business name and set the time period for which you want to generate the data for.
In the same dialog, choose among the different granularity available. You can choose between year, quarter, month, and day. You can also edit the dimension name here.
Currently, the calendar type supported is Gregorian only.
- Step 2
In the welcome page of the Data Builder, you can see the time table raw data and the corresponding time dimension (Year, Quarter, Month and Day) views.
You can preview the time table and the dimensions by clicking on them and then selecting the view icon to see the created data set according to the time period set up in step 1.
You can use any analytical dataset containing a date field to associate the generated time data.
Open the raw dataset to which you want to associate the time data.
In the properties sidebar, under Associations, click on the plus icon to create a new association.
Next, search and select the time data granularity you need for your raw dataset. This is going to be based on the date field you have in your dataset.
Click on OK to continue.
Associate your date field in the raw dataset by dragging the field to your chosen granularity.
Re-deploy the dataset by clicking on the deploy icon.
You have completed the Basic Data Modeling with Graphical Views tutorial group in SAP Data Warehouse Cloud. Now it is time to continue learning. Please check out the other SAP Data Warehouse Cloud tutorials available here, and do not forget to follow the SAP Data Warehouse Cloud tag in the SAP Community to hear about the most up to date product news.
- Step 3
What different types of time granularities you can associate with your data in SAP Data Warehouse Cloud?