Skip to Content

SAP HANA Analytical View

Now we will create an Analytic View which combines purchase order table data with the product attribute view we created in the previous step.

In your models package create a new Analytic View.

Name your new view AN_PURCHASE_ORDERS and click on finish.

Drag and drop the AT_PRODUCTS attribute view from the previous part of the exercise into the logical join of your new view. Add the purchase Order and purchase Order Item tables to the Data Foundation

Of your view.

Create a 1: N referential join between purchase Order and purchase Order Item on the Purchase Order Id column.

Now add the column Created At from the purchase Order table and the Purchase Order Id, Purchase Order Item, Product Id, Currency, and Gross Amount columns from the purchase Order Item table to the output

by clicking on the grey dot.

In the Semantics scenario, set the Default Schema to SAP_HANA_EPM_DEMO

Select the Logical Join box in the Scenario navigator at left.

You can then drag and drop the ProductId_1 from the data foundation to the Product Id column of the AT_PRODUCTS view creating a 1:1 referential join.

Return to the Semantics Scenario, set Gross Amount as a measure and the other fields as attributes.

Save and activate your Analytic View and then do data preview. (You can either right click on view name and select data preview or simply click on data preview icon)

You should see output similar to this.

You can also do the analysis of the Gross Amount by Country.

It will help Beginners.

For reference How to create the SAP HANA Attribute View

SAP HANA Attribute View

Thanks,

Phani.

To report this post you need to login first.

7 Comments

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

  1. Subhash Chandra Kilari

    Hi. This article is very useful for beginners like me. But I have small doubt regarding Analytic View. I know that we can not add measures in AT_View, and we can create CAL_View without measures in “Dimension”. My question is, can we create analytic view without measure? Is measure mandatory in Analytic View?

    Thanks.

    With regards,

    Subhash Chandra.

    (0) 
    1. Phani KV Post author

      Hi Subhash,

      for analytical view one measure is mandatory , without measure it will not activate.

      in the table measures is not there create the one ZCOUNT calculated column give constant value 1 then activate the view.

      for analytical view default node was star join, it will act like star schema, you are activating the any cube model should be one key figure or measure are mandatory.

      since SP 12 should not use the attribute, analytical view and we can use only calculation view.

      if you have already at view and analytical views migrate to calculation view.

      Thanks,

      Phani.

      (0) 
      1. S Kiran

        Hi Phani,

        very good post.. thanks for the nice efforts put in.

        One more addition to the above, in analytical views:
        –> without measures you cannot activate the object.
        –> no two transaction tables (i.e. tables with measures) can be added into a single analytical view.

        (0) 
  2. sree harsha

    Hi Phani,

    Can we create Analytic View without  Attribute Views that means, can we join the fact table with direct dimension tables. Can you plz explain the procedure?

    Thanks & Regards,
    Harsha.

    (0) 

Leave a Reply