Build Your First Analytic View

This article describes how to build a simple analytic view using data stored on SAP HANA.

Prerequisite:

• You have SAP HANA Studio installed on your machine (Section 3.2)
• You have added an SAP HANA system in HANA Studio (Section 3.3)
• You have created the attribute view as mentioned in Section 4.5 

In the analytic view, we will reuse that attribute view.

Steps for creating Analytic view:

1. Right click on the package and choose “New Analytic View.” Enter a name and a description and click “Finish”

2. Click on “+” sign of “Data Foundation” and add table SALES.

3. Right Click on the columns of table SALES and add REGION_ID and SALES_AMOUNT to output.

4. Click on “+” sign of “Logical Join” and add attribute view “AT_Region” which was created earlier.

5. Click on the REGION_ID from “Data Foundation” and connect it to the REGION_ID of attribute view AT_Region. In the properties pane select join type as left outer join and cardinality as n..1

6. Select “Sementics”. In the right side change the column type of SALES_AMOUNT as measure.

7. Activate the analytic view similar to attribute view.

Right-click on your analytic view and choose “Data Preview.” After that, you can browse through the tabs named raw data, distinct values, and analysis.

Congratulation!! You have successfully created your first Analytic View.

Click here to go to Next Chapter. 4.9 Overview of Calculation View