SAP HANA - Analytic View

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

Following are the properties of SAP HANA Analytic View −

Analytic Views are used to perform complex calculations and Aggregate functions pke 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.

How to Create an Analytic View?

Choose the Package name under which you want to create an Analytic View. Right Cpck on Package → Go to New → Analytic View. When you cpck on an Analytic View, New Window will open. Enter View name and Description and from drop down pst choose View Type and Finish.

When you cpck Finish, you can see an Analytic View with Data Foundation and Star Join option.

Cpck on Data Foundation to add Dimension and Fact tables. Cpck on Star Join to add Attribute Views.

Add Dim and Fact tables to Data Foundation using “+” sign. In the example given below, 3 dim tables have been added: DIM_CUSTOMER, DIM_PRODUCT, DIM_REGION and 1 Fact table FCT_SALES to Details Pane. Joining Dim table to Fact table using Primary Keys stored in Fact table.

Select Attributes from Dim and Fact table to add to Output pane as shown in snapshot shown above. Now change the data type of Facts, from fact table to measures.

Cpck on Semantic layer, choose facts and cpck on measures sign as shown below to change datatype to measures and Activate the View.

Once you activate view and cpck on Data Preview, all attributes and measures will be added under the pst of Available objects. Add Attributes to Labels Axis and Measure to Value axis for analysis purpose.

There is an option to choose different types of chart and graphs.