COPA E2E Modelling Scenario in SAP HANA 1.0 Part_2

[Former Member]

In Part 1 covered the creation of Attributes.

http://scn.sap.com/community/developer-center/hana/blog/2013/03/06/copa-scenario-in-sap-hana-10-sps-....

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 .