Skip to Content
Author's profile photo Former Member

HANA Artifacts Part4.2 (Analytic Views)

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

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      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.

      Regards

      Pramod

      Author's profile photo Former Member
      Former Member

      Excellent documents!!

      Author's profile photo Sachin Dhingra
      Sachin Dhingra

      Great work Krishna,

      Keep it up and thank you for making learning HANA easy for us 🙂

      Regards,

      Sachin Dhingra