Generate Time Data(财务日期主数据)
![](https://images2015.cnblogs.com/blog/717614/201512/717614-20151211234805997-921249044.png)
![](https://images2015.cnblogs.com/blog/717614/201512/717614-20151211234806434-103481859.png)
1. Generate the master data from the specific time frame that you are interested in根据你输入的时间段来产生主数据
•On the Quick Launch Page > Data > Generate Time Data
生成前,需指会计年度变式表与具体哪个变式
![](https://images2015.cnblogs.com/blog/717614/201512/717614-20151211234806762-1448785906.jpg)
注:一定要有T009这个标准表,且还要有数据,否则Variant下拉框中不会有值,下面是自己虚拟机真实情况:
![](https://images2015.cnblogs.com/blog/717614/201512/717614-20151211234807716-716795028.png)
![](https://images2015.cnblogs.com/blog/717614/201512/717614-20151211234808200-69693495.png)
2. Verify the generated data within _SYS_BI.M_FISICAL_CALENDAR
生成的账务主数据会放在_SYS_BI.M_FISICAL_CALENDAR表中
![](https://images2015.cnblogs.com/blog/717614/201512/717614-20151211234808919-2031490824.jpg)
![](https://images2015.cnblogs.com/blog/717614/201512/717614-20151211234809216-143845609.png)
3. Create a new Fiscal Time based Attribute view
•Right Click on Attribute View > New
![pastedImage_13.png](https://images2015.cnblogs.com/blog/717614/201512/717614-20151211234810216-823043328.png)
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.
![http://scn.sap.com/servlet/JiveServlet/downloadImage/102-26752-1-92099/380-400/pastedImage_17.png](http://scn.sap.com/servlet/JiveServlet/downloadImage/102-26752-1-92099/380-400/pastedImage_17.png)
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.
![](http://scn.sap.com/servlet/JiveServlet/downloadImage/102-26752-1-92100/pastedImage_24.png)
6. Right Click on the Attribute View > Activate
![](http://scn.sap.com/servlet/JiveServlet/downloadImage/102-26752-1-92101/pastedImage_29.png)
7. Right Click on the Attribute View > Preview
![](http://scn.sap.com/servlet/JiveServlet/downloadImage/102-26752-1-92105/pastedImage_31.png)
8. Use the Attribute view within an existing Analytical View AN_TIME_00.
在分析视图在使用上面创建的时间属性视图。AN_TIME_00为分析视图
•Right Click on Analytical View > Open
![](http://scn.sap.com/servlet/JiveServlet/downloadImage/102-26752-1-92106/pastedImage_34.png)
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)
![](http://scn.sap.com/servlet/JiveServlet/downloadImage/102-26752-1-92107/pastedImage_40.png)
12. Activate & Preview
这样就可以按会计变式进行数据分析了
![](https://images2015.cnblogs.com/blog/717614/201512/717614-20151211234810637-619938768.jpg)
原文出自 江正军 技术博客,博客链接:www.cnblogs.com/jiangzhengjun