Generating time data in SAP HANA

To generate time data and replicate your data, follow below steps −

In the SAP HANA Studio in the Modeler perspective, on the Quick Launch tab, select the relevant SAP HANA system and choose Generate Time Data.

In the field Calendar Type, select Gregorian.

Enter the period for which you want to generate data. You should generate time data for all years for which data can occur in your application (Ex: 1999 to 2020).

Select Granularity Day → Finish