The “Generate Time Data Wizard” from the modeler will generate time data into tables that are depenend of:
- the type op calendar (Gregorian, Fiscal)
- the granularity (Year,Month,…)
see HANA - Date Time
if your financial year is same as the calendar year (January to December)
For the Gregorian calendar type, modeler generates data into
-- Granularity year select * from _SYS_BI.M_TIME_DIMENSION_YEAR; -- Granularity month select * from _SYS_BI.M_TIME_DIMENSION_MONTH; select * from _SYS_BI.M_TIME_DIMENSION_WEEK, select * from _SYS_BI.M_TIME_DIMENSION;
If the financial year is not same as the calendar year, for example, March to April.
For the Fiscal calendar type, the modeler populates the generated time dimension data into the M_FISCAL_CALENDAR table.
Gregorian calendar > Month granularity > For the year 2016 until 2016