SAP HANA, XS Advanced - Dimension Calculation Views

This video is a part of the XS Advanced tutorial series in developers.sap.com. It demonstrates how to create a Calculation View of type Dimension using the SAP HANA Interactive Education data model.
Prerequisite for this tutorial: www.sap.com/de...
SAP HANA 2.0, SPS1

[@naveenkumarkc2141]

Do you have any Playlist for HANA XSA

[@chloehii7633]

Hi Lucia,
How about calculation view with time dimension where standard time-related tables like M_TIME_DIMENSION_YEAR, M_TIME_DIMENSION_MONTH, M_TIME_DIMENSION_WEEK, M_TIME_DIMENSION are required? I am using trial Hana XSA Web IDE on GCP and i dont see any SYS_BI schema. Can i actually create the time-related tables myself in Web IDE? If yes, how can i generate time-related data?

[@LuciaSubatin]

Hi, Chloe! If you are in SPS03, right click on the database module --> modelling actions --> Maintain time data. The wizard will generate tables and their data if they are not present. If you are looking for the same functionality for plain schemata (like the time generation from HANA Studio), you can right click on the connection to, for example, the tenant HXE and choose "Generate Time Data" from the database explorer

[@MikeHowles]

You can, however I do not know how to generate the data in the DEPLOYed version.