SAP HANA中创建与时间相关的数据及Time Attribute View（Fiscal）

This document provides the general functionality and idea about the "Generate Time Data" with calender type "Fiscal".

In order to better understand how to use “Generate Time Data”, we are going to use standard table for the examples.

Note: While using this option you need to replicate the standard table into SAP HANA that is T005T, T005U, T009, and T009B. If these standard tables are not available then you will not be able use the “Generate Time Data” function.

Procedure:

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

专注于企业信息化，最近对股票数据分析较为感兴趣，可免费分享股票个股主力资金实时变化趋势分析工具，股票交流QQ群：457394862

分类:  SAP HANA

本文转自沧海-重庆博客园博客，原文链接：http://www.cnblogs.com/omygod/archive/2013/04/20/3031850.html，如需转载请自行联系原作者