HANA - Generate Time Data

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

_


Powered by ComboStrap