Skip to Content

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-5part1doc.

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)

/wp-content/uploads/2013/03/00_196076.jpg

1. Create an analytical view AV_ACTUAL_XX with the description Contribution Margin for Actuals.

As a result you should see below screen.

/wp-content/uploads/2013/03/1_196078.jpg

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.

/wp-content/uploads/2013/03/2_196079.jpg

3.In the details screen , select PERIO,KNDNR,ARTNR,AKORG,VV010,VV070,VV0290 & VV0960

Right Click > Add to Output

/wp-content/uploads/2013/03/3_196080.jpg

4.  Join DataFoundation.ARTNR to AT_PRODUCT_MATNR.

5.  Join DataFoundation.KNDNR to AT_LOCATION_KUNNR.

/wp-content/uploads/2013/03/4_196081.jpg

6. Define the calculated measures to be included in the analytic view.

Right click on Calculated Measures and choose New.

/wp-content/uploads/2013/03/5_196087.jpg

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.

/wp-content/uploads/2013/03/5_196087.jpg


  • 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.

/wp-content/uploads/2013/03/7_196092.jpg

/wp-content/uploads/2013/03/8_196101.jpg

8. Validate the Analytic view, Active & click preview to see data.

/wp-content/uploads/2013/03/9_196103.jpg

9.Result will appear in the below screen.

/wp-content/uploads/2013/03/10_196104.jpg

/wp-content/uploads/2013/03/11_196105.jpg

/wp-content/uploads/2013/03/12_196109.jpg

/wp-content/uploads/2013/03/13_196110.jpg

/wp-content/uploads/2013/03/13_196110.jpg

10. Navigate to the Catalog.  Select the folder _SYS_BIC, expand Column Views and locate you Analytic View.

Last.jpg

————————————————————————————————————————————–

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.

/wp-content/uploads/2013/03/11_196105.jpg

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.

/wp-content/uploads/2013/03/12_196109.jpg

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.

/wp-content/uploads/2013/03/12_196109.jpg

14 .In the details screen , select PERIO,KNDNR,ARTNR,AKORG,VV010001,VV070001,VV290001 & VV960001

Right Click > Add to Output

/wp-content/uploads/2013/03/14_196161.jpg


14. Join DataFoundation.ARTNR to AT_PRODUCT_MATNR. 

15.  Join DataFoundation.KNDNR to AT_LOCATION_KUNNR.

/wp-content/uploads/2013/03/15_196162.jpg

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.

/wp-content/uploads/2013/03/16_196169.jpg

/wp-content/uploads/2013/03/17_196170.jpg

Notice there is now a filter icon next to the PALEDGER and VRGAR.

/wp-content/uploads/2013/03/18_196171.jpg

17. Define the calculated measures to be included in the analytic view.

Right click on Calculated Measures and choose New.

/wp-content/uploads/2013/03/19_196175.jpg

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.

/wp-content/uploads/2013/03/20_196176.jpg

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

20A.jpg

19. In the below screen under Calculated columns you can can new columns.

/wp-content/uploads/2013/03/21_196178.jpg

20.Validate & Active the analytic View.

Preview the data

/wp-content/uploads/2013/03/22_196179.jpg

/wp-content/uploads/2013/03/23_196180.jpg

/wp-content/uploads/2013/03/24_196181.jpg

Thanks for reading this series blogs.

Part 3 URL

http://scn.sap.com/docs/DOC-40442

Thanks for your time .




To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

  1. Koundinya Karanam

    Really good one Mahesh!! Appreciable work.. People always look for screenshots when they don’t have system in place. This will be very useful for them..

    Thanks for the nice blog.. Hope to see more from you!!

    (0) 

Leave a Reply