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 http://scn.sap.com/docs/DOC-25977
Procedure:
1. Generate the master data from the specific time frame that you are interested in
2. Verify the generated data within _SYS_BI.M_FISICAL_CALENDAR
3. Create a new Fiscal Time based Attribute view
4. Enter FISCAL_00 for the name of the view
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.
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.. :smile:
Thanks for reading the document.
Regards,Neha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Subject | Kudos |
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
User | Count |
---|---|
9 | |
8 | |
7 | |
5 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 |