Skip to Content

COPA E2E Modelling Scenario in SAP HANA Part_3

In this blog ,  I am going to explain creation of Calculation view ( Graphical).

SAP HANA Model for COPA Scenario

A1.jpg

Previous Blogs:


Attribute Views: (Part 1)

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

Analytic View : ( Part 2)

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

Calculation View Intro:

Calculation views are composite views used on top of analytic and attribute views.

Calculation views combine different fact tables

Calculation views are defined as either graphical views or scripted views depending on how they are created

Graphical views can be modeled using the graphical modeling features of the SAP HANA Modeler

Scripted views are created as sequences of SQL statements.

Typically used when the business use case requires advanced logic that is not covered in the previous types of information views

For example, calculation views can have layers of calculation logic, can include measures sourced from multiple source tables, can include advanced SQL logic, and so on

The data foundation of the calculation view can include any combination of tables, column views, attribute views and analytic views.

You can create joins, unions, projections, and aggregation levels on the sources.

Creation of Calculation View

  1. Create a new Calculation View.

/wp-content/uploads/2013/04/1_205941.jpg

  2. Name calculation view CVG_COPA_UNION,

      Specify Graphical for the type of the Calculation View.

      Click Next.

/wp-content/uploads/2013/04/2_205942.jpg

  3. Will be reading from existing Anal analytic views you do not have to select any tables. Select the analytic view both

     Click Next.

/wp-content/uploads/2013/04/3_205997.jpg

4. As a result the Graphical Calculation View editor will open.

/wp-content/uploads/2013/04/4_205998.jpg

5. From the Tools Palette select 2 Projection graphical nodes one for each Analytical View.

    Select Union as well.

/wp-content/uploads/2013/04/5_205999.jpg

6. With the mouse pointer over each graphical node and draw a connection line between the nodes.

/wp-content/uploads/2013/04/6_206003.jpg

7. Click on each Projection node and rename each to Projection_A and Projection_P.

/wp-content/uploads/2013/04/7_206279.jpg

8. Add a new Calculated Column called KPLIKZ for Projection_A

/wp-content/uploads/2013/04/8_206280.jpg

8A.jpg

9.  Add a new Calculated Column called KPLIKZ for Projection_P

/wp-content/uploads/2013/04/9_206282.jpg

9A.jpg

10.  Select the Projection P node, within the details view select all the fields > Right Click > Add to Output.

       Repeat the same step for projection A node.

/wp-content/uploads/2013/04/10_206285.jpg

11. Proceed to select and work with the Union node. Within the details of the Union ,select all the fields from the Projection_A node > Right Click > Add to Target, Repeat the same for Projection P.

/wp-content/uploads/2013/04/11_206287.jpg

12. Click on the Output Node in the main diagram. Within the Details view pane select each field > Right Click > ‘And the field as a Attribute’ or as Measure according to the following.

/wp-content/uploads/2013/04/12_206288.jpg

13. Save & Validate then  Activate View, Click Data Preview to see the output of the view

Click Distinct Values to see the distinct values , as result you will see below screen.

/wp-content/uploads/2013/04/13_206289.jpg

14.Click Analysis to see the output of the view in the graphical representation.

/wp-content/uploads/2013/04/14_206291.jpg

Script Based Calculation View in COPA Scenario_Part 4

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

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