Currently Being Moderated

Generate Time Data in SAP HANA - Part 2

Hello Everyone,


In this document, I tried to explain "Generate Time Data" functionality. Through this, I am trying to provide the general idea about the "Generate Time Data" using Calendar Type “Fiscal”.

This is the continuation of the previous document




1. Generate the master data from the specific time frame that you are interested in

  • On the Quick Launch Page > Data > Generate Time Data



2. Verify the generated data within _SYS_BI.M_FISICAL_CALENDAR


3. Create a new Fiscal Time based Attribute view

  • Right Click on Attribute View > New


4. Enter FISCAL_00 for the name of the view

  • For the Calendar Type Select > Fiscal.
  • For the variant select K4:800
  • Click on Auto Create.
  • Click Finish.


5. As a result you will see the fiscal calendar table with the generated Attributes.

     Note: Optionally you can remove any attribute fields that are not needed.


6. Right Click on the Attribute View > Activate



7. Right Click on the Attribute View > Preview


8. Use the Attribute view within an existing Analytical View AN_TIME_00.

  • Right Click on Analytical View > Open


9. Open the logical view.

10. Drag the FISICAL_00 attribute view into the Analytical views logical view.

11. Create a join (referential n..1) between FISCAL_00.DATE and the data foundation HZDAT field.



12. Activate & Preview



Hope it is useful for all..


Thanks for reading the document.




Delete Document

Are you sure you want to delete this document?