SAP HANA - How to create an Analytic View intro

[NagaPrakashT]

Today we will create an Analytic View which is one of the artifacts of the HANA. Please go through my previous post which describes about Attribute view.SAP HANA - How to create an Attribute View

What is an Analytic View ?

1.Analytic view is an information view.

2.It joins together one central fact table, which contains the measures with any number of other tables (or) attribute views.

3.This is the basic view type that is directly used as source of data for reporting.

4.Analytic view can be comparable to InfoCubes in SAP BW.

Analytic View = 1 Fact Table(with Key figures) + ( 1 or more Tables/Attribute views ).

In this example we will use one fact table from EPM demo data model and an attribute view which is create in my earlier post..SAP HANA - How to create an Attribute View

You can avail the 30days Free trail here Get 30 days of free access to SAP HANA, developer edition

1. Using Quick Launch,choose ANALYTIC VIEW and click create. Alternatively right-click in the navigator pane on the desired package and click NEW and then ANALYTIC VIEW.

2. In the dialog box that comes up fill in the necessary information and Click on Finish.

3.Now you see the below screen.There are 3 parts in Analytic View to be look at (a)Semantics (b)Logical Join and (c)Data Foundation.

4.Data Foundation is in which we built the Fact table by using one or more tables from the Schema.Here i am using only 2 table Sales Order Header and item table from EPM data model.These two tables are joined and output columns are determined like below.By this our fact table is ready with key figures Gross Amount,Net Amount and Quantity.

Note: Only tables are used in the Data Foundation

5. Next step will be Logical Join here we are going to join the Fact table created in above step with other Attribute Views(Dimensions) : Customer and Material

Note: Only Attribute Views(dimensions) are used in the Logical Join.

The Logical Join will look like this.

6. Save and activate the Analytic View. Preview data will look like below.

All the activated Attribute and Analytic Views can found in _SYS_BIC schema(run time objects).

We can use this analytic View in any HANA native development applications like SAPUI5 applications.

Happy Learning..:)

Please don't forgot to post comments and correct me if i am wrong.