Skip to Content
Author's profile photo Former Member

COPA E2E Modelling Scenario in SAP HANA Part_1

Part 1 covers technical steps for attribute view creation & Little introduction to COPA & Attribute View.

Controlling & Profitability Analysis in SAP HANA


Profitability Analysis (CO-PA) enables you to evaluate market segments, which can be classified according to products, customers, orders or any combination of these, or strategic business units, such as sales organizations or business areas, with respect to your company’s profit or contribution margin.

The aim of the system is to provide your sales, marketing, product management and corporate planning departments with information to support internal accounting and decision-making.


Two forms of Profitability Analysis are supported: costing-based and account-based.


  • Costing-based Profitability Analysis is the form of profitability analysis that groups costs and revenues according to value fields and costing-based valuation approaches, both of which you can define yourself. It guarantees you access at all times to a complete, short-term profitability report.


  • Account-based Profitability Analysis is a form of profitability analysis organized in accounts and using an account-based valuation approach. The distinguishing characteristic of this form is its use of cost and revenue elements. It provides you with a profitability report that is permanently reconciled with financial accounting.

You can also use both of these types of CO-PA simultaneously.


/wp-content/uploads/2013/03/0_192401.jpg

COPA Model in SAP HANA

/wp-content/uploads/2013/03/01_192402.jpg

Before creating information models you need to provision the source data to SAP HANA.

Customer attribute view is created based on KNA1, T005U & T005T tables.

Product attribute is created based on MARA & MAKT tables.


Actual Analytic view is based on CE1IDEA & Customer & Product Attribute Views.

Plan Analytic view is based on CE2IDEA & Customer & Product Attribute Views

Attribute View introduction

Attribute Views are used to model an entity based on the relationships between attribute data contained in multiple source tables.

You can model the columns & calculated elements within an attribute view.

Simple attributes are individual non-measurable analytic elements that are derived from the data foundation.

For example, PRODUCT_ID and PRODUCT_NAME are attributes of a PRODUCT subject area.

Calculated attributes are derived from one or more existing attributes or constants.

For example, deriving the full name of a customer (first and last name), assigning a constant value to an attribute that can be used for arithmetic calculations.

Defines joins between tables and selects a subset (or all) of their columns. The rows selected can also be restricted by filters. An additional application of attribute a view is as dimensions in the star schema defined by an analytic view. In this use

case, the attribute view adds more columns and also hierarchies as further analysis

Criteria to the analytic view. In the star schema of the analytic view the attribute view is shown as a single dimension table (although it might join multiple tables), that can be joined to a fact table.

  SAP HANA modeler is a graphical data modeling tool which allows you to design analytical models and later analytical privileges, that governs the access to those models.

1.Create a new package. Select the Content folder > Right Click > New Package.

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

1A.jpg

2.Select your package, Give the name details.

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

3.As a result you should see following screen.

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

4.Drag & drop MARA & MAKT tables in to Data Foundation.

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

5.In the details screen, select MATNR & Right Click > Add to Output.

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

6.In the properties screen, select Key Attribute change it to True to enable as Key.

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

7. Connect MATNR(MARA) to MATNR (MAKT), In the properties select join type as Text Join , Language column as SPARS &          Cardinality as 1:1.

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

8. Select MTART, MBRSH, MATKL fields as Add to Output.

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

9. As a result you should see all columns in the output frame & Click Validate.

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

10. Activate the attribute view.

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

11.Click Data Preview to see the output of the view.

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

12.Click Raw Data to see the output of the view in the column format.

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

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

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

14.Click Distinct Values to see the distinct values.

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

Attribute View for Customer

1. Select package – Click New & select attribute view

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

2. Specify the technical name.

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

3.Drag & drop KNA1,T005T & T005U table in to Data Foundation , In the details screen , select KUNNR & Right Click > Add to Output.

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

4.Connect LAND1(KNA1) to LAND1 (T005U), In the properties select join type as Text Join , Language column as SPARS & Cardinality as 1:1.

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

5.Connect REGIO(KNA1) to BLAND (T005U), In the properties select join type as Text Join , Language column as SPARS & Cardinality as 1:1.

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

6.Connect LAND1(KNA1) to LAND1 (T005T), In the properties select join type as Text Join , Language column as SPARS & Cardinality as 1:1.

/wp-content/uploads/2013/03/6_192451.jpg

7. Select LAND1,ORT01,REGIO,LANDX & BEZEI fields as Add to Output.

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

8.As a result you should see all columns in the output frame.

   Validate & Activate View

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

9.Click Data Preview to see the output of the view

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

10.Click Data Preview to see the output of the view.

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

Navigate to the Catalog.  Select the folder _SYS_BIC, expand Column Views and locate your Attribute Views.

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

2. COPA E2E Modelling Scenario in SAP HANA 1.0 Part_2

3.  COPA E2E Modelling Scenario in SAP HANA Part_3

4. Script Based Calculation View in COPA Scenario_Part 4


Thanks for reading.

Assigned Tags

      10 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      CO-PA Scenario was already covered in the training material for both SP4 and SP5 in 300 series. It was great to put in pictorial format. The above example looks to be based on Cost based with Contribution Margins example.

      thanks the blog and nice explanation.

      It would be great if you can add Account based and I was looking for some scenarios for a General Ledger based reporting in SAP HANA and landed in your blog.

      Good luck with your part 2 and 3.

      Author's profile photo Former Member
      Former Member

      I agree with you , This is genral platform to share knowledge , This will be helpful for those who are not taken training from SAP.

      Shortly you can expect some blogs on GL.

      Author's profile photo Aby Jacob
      Aby Jacob

      Dear Mahesh,

      Thanks for all the info/pictures, This is valuable for many Customers.

      Looking forward to more such inputs ... πŸ™‚

      Author's profile photo Former Member
      Former Member

      Nice share

      Author's profile photo Former Member
      Former Member

      Dear Mahesh,

      Thanks for explaining step by step..

      Nice document for the beginners.

      Expecting some more docs like this on GL..

      Author's profile photo Rama Shankar
      Rama Shankar

      Nice blog - Thanks! πŸ™‚

      Author's profile photo Former Member
      Former Member

      very nice blog

      Author's profile photo Deepak Singh
      Deepak Singh

      The screeshots for step 6,7 and 8 are not correct.

      Author's profile photo vara prasad Puram
      vara prasad Puram

      very nice explanation

      Regards,

      Vara.

      Author's profile photo Ashok Babu Kumili
      Ashok Babu Kumili

      Hello,

      Thank you for the details.