HANA - Generate Time Data

Sap Hana Architecture

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

Sap Hana Modeler Time Data





Discover More
Sap Hana Architecture
Attribute views

are used to model an entity based on the relationships between attribute data contained in multiple source tables. You can add to the attribute view: more columns and also hierarchies Analytic...



Share this page:
Follow us:
Task Runner