About
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
Calendar Type
Gregorian
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;
Fiscal
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.
Example
Gregorian calendar > Month granularity > For the year 2016 until 2016
