Skip to Content

In my last document we created an attribute view
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.


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.




Insert the logic join between Fact table and Attribute view.



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



Please refer wonderful video tutorial from Thomas Jung:

In next document we use the above 03 analytic view to create a calculation view . Till then happy learning ๐Ÿ˜› ๐Ÿ™‚ ๐Ÿ™‚ ….

Ref. Analytic View which will take Variables/Input Parameters

To report this post you need to login first.


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

  1. Former Member

    Hi Krishna,

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

    Appreciate your effort!!. Thanks again.




Leave a Reply