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
Previous Blogs:
Attribute Views: (Part 1)
Analytic View : ( Part 2)
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
- Create a new Calculation View.
2. Name calculation view CVG_COPA_UNION,
Specify Graphical for the type of the Calculation View.
Click Next.
3. Will be reading from existing Anal analytic views you do not have to select any tables. Select the analytic view both
Click Next.
4. As a result the Graphical Calculation View editor will open.
5. From the Tools Palette select 2 Projection graphical nodes one for each Analytical View.
Select Union as well.
6. With the mouse pointer over each graphical node and draw a connection line between the nodes.
7. Click on each Projection node and rename each to Projection_A and Projection_P.
8. Add a new Calculated Column called KPLIKZ for Projection_A
9. Add a new Calculated Column called KPLIKZ for Projection_P
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.
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.
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.
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.
14.Click Analysis to see the output of the view in the graphical representation.
Script Based Calculation View in COPA Scenario_Part 4
Thanks for the nice series of blogs.. Appreciate your effort..
thanks
This is great, can we have this Profit center Modelling Scenario in SAP HANA
Yes Joseph ,
you can model the solution..
Currently is no hierarchy support similar to NetWeaver or BW in HANA but you can model the solution from the scratch.
Thanks Mahesh,
I am new to SAP and HANA Studio; can you please guide me on how to build standard cost center/profit center hierarchy in HANA Studio database using SETLEAF, SETNODE AND SETHEADER? I will need to implement this in attribute view and connect it to GLPCA for GR55 profit and Loss statement report. Below is my attribute view for the profit center/Cost center hierarchy. The issue with this model is that I can only move two levels down the hierarchy.
Model
Dim_Profit_Center_Hierarchy using inner join to join Setleaf, setnode and setheader using setnode.setname
Analytic views on GLPCA join CEPT (RPRCTR), CSKT(KOSTL) and DIMCOST_PROFIT(VALFROM)
Thanks for sharing knowledge 🙂
I can not access Part 4 attached..
Script Based Calculation View in COPA Scenario_Part 4
http://scn.sap.com/docs/DOC-41293
Access to this place or content is restricted
I´m with the same problem.
It has excellent content Thanks alot. Could you please suggest how can access Part 4 section. I am login to SCN but not have access this file. could you please suggest how to access the file
Script Based Calculation View in COPA Scenario_Part 4
http://scn.sap.com/docs/DOC-41293
I do not have access to Part 4. Please let me know how I can access.
Thanks.
I do not have access to Part 4. Please let me know how I can access.
Thanks.
Radha krishna
please see the below error while click on part 4:
Access to this place or content is restricted. If you think this is a mistake, please contact your administrator or the person who directed you here.
Hi Mahesh,
Really good stuff. However can't access part 4, can you please help.
Regards
Jitendra
Hi Mahesh,
Please suggest on how to access the Part 4. Seeking your kind help.
Regards
Suraj
Hi Mahesh,
Thank you for the valuable details here.