In Part 1 covered the creation of Attributes.
Now Part 2 covers Analytic Views.
COPA Analytical View ACTUAL DATA
This Analytic view Is based on CE2DEA table & following attribute views
Material Attribute View ( MARA,MAKT tables)
Customer Attribute View (KNA,T005U,T005T Tables)
1. Create an analytical view AV_ACTUAL_XX with the description Contribution Margin for Actuals.
As a result you should see below screen.
2. Drag & drop CE1IDEA table in to Data Foundation.
Navigate to your package, expand the folder and select the attribute views for PRODUCT and LOCATION and drop in to Logical Join.
3.In the details screen , select PERIO,KNDNR,ARTNR,AKORG,VV010,VV070,VV0290 & VV0960
Right Click > Add to Output
4. Join DataFoundation.ARTNR to AT_PRODUCT_MATNR.
5. Join DataFoundation.KNDNR to AT_LOCATION_KUNNR.
6. Define the calculated measures to be included in the analytic view.
Right click on Calculated Measures and choose New.
Create the first Calculated Measure, Net Revenue.
Select Decimal data type with length 15,0
Double click on the desired measure for it to appear in the expression editor. Either type in the minus sign or double click on the Operator.
- Continue to create all other needed Calculated Measures.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Name | Description | Data Type | Length | Formula |
CM1 | Contribution Margin 1 | DECIMAL | 15 | NetRevenue –ProductVariance |
CM2 | Contribution Margin 2 | DECIMAL | 15 | CM1 -OtherExpenses |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7. Navigate to Data Foundation Tab, where we will define filters.
- Apply filters on the fields PALEDGER and VRGAR (record type).
- Select PALEDGER > right click > Apply Filter.
- Choose Operator Equal from the Apply Filter dialog box & Specify the value 01.
- For VRGAR, choose Operator Equal and specify the value F.
8. Validate the Analytic view, Active & click preview to see data.
9.Result will appear in the below screen.
10. Navigate to the Catalog. Select the folder _SYS_BIC, expand Column Views and locate you Analytic View.
--------------------------------------------------------------------------------------------------------------------------------------
COPA Analytic View PLAN DATA
This Analytic view Is based on CE2IDEA table & below attribute views.
Material Attribute ( MARA,MAKT tables)
Customer (KNA,T005U,T005T Tables)
11.Create an analytic view AV_PLAN_XX with the description Contribution Margin for Plan.
As a result you should see below screen.
12. Drag & drop CE2IDEA table in to Data Foundation.
Navigate to your package, expand the folder and select the attribute views for PRODUCT and LOCATION and drop in to Logical Join.
13 .Navigate to the Logical View Tab to see the two attribute views.
- Note that the Data Foundation is empty.
- It will be filled once you select your columns.
14 .In the details screen , select PERIO,KNDNR,ARTNR,AKORG,VV010001,VV070001,VV290001 & VV960001
Right Click > Add to Output
14. Join DataFoundation.ARTNR to AT_PRODUCT_MATNR.
15. Join DataFoundation.KNDNR to AT_LOCATION_KUNNR.
16. Navigate to Data Foundation Tab, where we will define filters.
• Apply filters on the fields PALEDGER and VRGAR (record type).
• Select PALEDGER > right click > Apply Filter & Choose Operator Equal from the Apply Filter dialog box, Specify the value 01.
• For VRGAR, choose Operator Equal and specify the value F.
Notice there is now a filter icon next to the PALEDGER and VRGAR.
17. Define the calculated measures to be included in the analytic view.
Right click on Calculated Measures and choose New.
Create the first Calculated Measure, NetRevenue.
- Select Decimal data type with length 15,0
Double click on the desired measure for it to appear in the expression editor. Either type in the minus sign or double click on the Operator.
18. Continue to create all other needed Calculated Measures.
Name Description Data Type Length Formula
--------------------------------------------------------------------------------------------------------------------------------------------
CM1 Contribution Margin 1 DECIMAL 15 NetRevenue –ProductVariance
CM2 Contribution Margin 2 DECIMAL 15 CM1 -OtherExpenses
19. In the below screen under Calculated columns you can can new columns.
20.Validate & Active the analytic View.
Preview the data
Thanks for reading this series blogs.
Part 3 URL
http://scn.sap.com/docs/DOC-40442
Thanks for your time .
- SAP Managed Tags:
6 Comments
