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

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

image

2. Verify the generated data within _SYS_BI.M_FISICAL_CALENDAR

image

3. Create a new Fiscal Time based Attribute view

  • Right Click on Attribute View > New

image

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.

image

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.

image

6. Right Click on the Attribute View > Activate

image

7. Right Click on the Attribute View > Preview

image

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

  • Right Click on Analytical View > Open

image

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.

image

12. Activate & Preview

image

版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 举报,一经查实,本站将立刻删除。

发布者:全栈程序员-用户IM,转载请注明出处:https://javaforall.cn/110157.html原文链接:https://javaforall.cn

【正版授权,激活自己账号】: Jetbrains全家桶Ide使用,1年售后保障,每天仅需1毛

【官方授权 正版激活】: 官方授权 正版激活 支持Jetbrains家族下所有IDE 使用个人JB账号...

(0)
blank

相关推荐

发表回复

您的电子邮箱地址不会被公开。

关注全栈程序员社区公众号