Generate Time Data（财务日期主数据）

 

 

1. Generate the master data from the specific time frame that you are interested in根据你输入的时间段来产生主数据

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

生成前，需指会计年度变式表与具体哪个变式

 

 

注：一定要有T009这个标准表，且还要有数据，否则Variant下拉框中不会有值，下面是自己虚拟机真实情况：

2. Verify the generated data within _SYS_BI.M_FISICAL_CALENDAR

生成的账务主数据会放在_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.

在分析视图在使用上面创建的时间属性视图。AN_TIME_00为分析视图

•Right Click on Analytical View > Open

 

9. Open the logical view.

 在新版本Studio中为Star Join

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

 将 FISICAL_00时间属性视图加入到分析视图的Logical view（新版Star Join）

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

通过日期关联（YYYYMMDD）

 

12. Activate & Preview

 这样就可以按会计变式进行数据分析了