Generate Time Table and Dimensions
- How to create time tables and dimensions
- How to associate the time dimensions with your data
jmmargoMarch 13, 2023
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.
- Step 1
-
Go to the space management icon in the SAP Datasphere 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.
Well done!
You have completed the Basic Data Modeling with Graphical Views tutorial group in SAP Datasphere. Now it is time to continue learning. Please check out the other SAP Datasphere tutorials available here, and do not forget to follow the SAP Datasphere tag in the SAP Community to hear about the most up to date product news.
-