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.
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: 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