HANA Analytic View

Analytic View Introduction

Analytic View is in the form of Star schema, wherein we join one Fact table to multiple Dimension tables. Analytic views use real power of SAP HANA to perform complex calculations and aggregate functions by joining tables in form of star schema and by executing Star schema queries.

Characteristics of Analytic View

Analytic Views are used to perform complex calculations and Aggregate functions like Sum, Count, Min, Max, Etc.
Analytic Views are designed to run Start schema queries.
Each Analytic View has one Fact table surrounded by multiple dimension tables. Fact table contains primary key for each Dim table and measures.
Analytic Views are similar to Info Objects and Info sets of SAP BW.

Creating Analytic View

1. Go to your Package Right click--> New--> Analytic View
   
   
2. Give the Name and Description of Analytic View
3. Next screen will show Data foundation and star join. In data foundation you will give the Fact table and in star join you will put dimension means Attribute view
   
   
4. Now in data foundation add the fact table and select the column which is required. after selection the fields you can see them in right side column folder
    
5. Now add attribute view in Star join field like for the below case we are adding 3 attribute view AT_CUSTOMER, AT_PRODUCTS, AT_TIME
   
   
6.  Now make the join between fact table and Attribute view
   
   
7.  Now run the view and check the output
   
   
   
   
   
   For more information please mail me at Sandeepcg1989@gmail.com