Skip to Content

In my last document we created an attribute view http://scn.sap.com/community/developer-center/hana/blog/2013/11/12/hana-artifacts-part4.
Now we will move to the next HANA specific view i.e. Analytic View…..

These views run inside the OLAP/Analytic engine of SAP HANA, leveraged the computational capability of HANA to calculate aggregates…… Contains
two type of columns (i.e. attributes and measures).

In My last document we have created an Attribute view to get the discount based on ‘YEAR’. Now we will use that view (‘KC_ATT_V_PRODUCT_DISCOUNT’) and KC_SALES table to create our Analytic View.

Let’s first see the relationship between the View and KC_SALES table.

/wp-content/uploads/2013/11/1_322708.png

Scenario
we will be creating 03 Analytic Views to get the sales for YEAR: 2011, 2012, and 2013.

Let’s start create our first analytic view for year 2011.

/wp-content/uploads/2013/11/1_322708.png

/wp-content/uploads/2013/11/1_322708.png

/wp-content/uploads/2013/11/1_322708.png

Insert the logic join between Fact table and Attribute view.

/wp-content/uploads/2013/11/1_322708.png

/wp-content/uploads/2013/11/1_322708.png

Save and activate the first view, below is the data preview of view.

/wp-content/uploads/2013/11/1_322708.png

/wp-content/uploads/2013/11/1_322708.png/wp-content/uploads/2013/11/1_322708.png

Please refer wonderful video tutorial from Thomas Jung: https://open.sap.com/videos/129?module_item_id=297

In next document we use the above 03 analytic view to create a calculation view http://scn.sap.com/community/developer-center/hana/blog/2013/11/13/hana-artifacts-part43calculation-views . Till then happy learning 😛 🙂 🙂 ….

Ref. Analytic View which will take Variables/Input Parameters http://scn.sap.com/community/developer-center/hana/blog/2013/11/20/hana-artifacts-part42-analytic-views-continued

To report this post you need to login first.

3 Comments

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

  1. Pramod Savanoor

    Hi Krishna,

    Thanks for sharing series of document of HANA development. Great to see step by step guide.

    Appreciate your effort!!. Thanks again.

    Regards

    Pramod

    (0) 

Leave a Reply