- SAP HANA
- Features of SAP HANA
- Advantages and Disadvantages of SAP HANA
- SAP HANA Architecture
- SAP HANA Use Cases
- SAP Hana Installation
- SAP Hana Studio
- SAP HANA Studio Administration Console
- How to Use SAP HANA System Monitor
- How to Use SAP HANA on Azure
- SAP HANA Modeling – Attributes, Measures, Privileges, Modeling Objects
- Data Warehousing in SAP HANA – Components, Methods, Working & Benefits
- SAP HANA Attribute View – Create Attribute View in 9 Easy Steps
- SAP HANA Analytic View
- SAP HANA Calculation View
- Tables in SAP HANA
- SAP HANA Packages
- Schema in SAP HANA
- How to Create Analytic Privileges in SAP HANA
- SAP HANA Information Composer
- Import and Export in SAP HANA
- Major Components of SAP HANA
- Reporting in SAP HANA
- SAP Bussiness Objects Reporting Tool
- create relational connection in sap hana in 8 steps/
- steps to create olap connection in sap hana/
- How to Connect SAP Lumira with SAP HANA
- Connect Dashboard Designer to SAP HANA & Create Stunning Dashboards
- How to Connect Web Intelligence to SAP HANA in 4 Ways – Seamless Process
- Replication Modes and Types in SAP HANA
- SAP HANA Sidecar Scenario
- SAP HANA Security Guide
- SAP HANA License Management
- Difference between SAP HANA vs SAP S/4 HANA
- What is SAP S/4 HANA?
- S/4HANA Editions
- SAP S/4HANA Lines of Business
- >SAP S/4HANA Deployment Options
- >SAP S/4HANA Overview
- >Introduction of SAP ABAP
- >Overview of SAP ABAP
- >SAP R3 ARCHITECTURE
- >SAP Data Dictionary
- >SAP ABAB Views
- >SAP ABAB database Tables
SAP HANA Analytic View
After learning about the Attribute View, let’s move on to understanding the Analytic View.
What is SAP HANA Analytic View?
The Analytic Views in SAP HANA are one step ahead in terms of complexity as compared to the Attribute View. The Analytic Views are multi-dimensional views involving attributes and measures arranged in a star schema fashion.
In the center lies the fact table, which is a table containing measure columns from the transactional SAP HANA database.
Surrounding this fact table is a different set of attribute tables/views. The attributes or dimensions attached to the fact table making an analytic view provides relevance to the measures in the fact table. Thus, a user can examine data (transactional data) from different perspectives.
For instance, you can have a fact table named Sales linked to four attribute views or dimensions such as Region, Period, Customer, and Product. That is, sales can be analyzed with respect to the regions, customers, years, or products.
The multi-dimensional view created in the analytic view is also representative of OLAP cubes.
Features of SAP HANA Analytic View
Some important features of the analytic view in SAP HANA are:
- Analytic views run start schema queries.
- The measures used in the fact table can be calculated measures or restricted measure.
- You can perform complex calculations and apply aggregation functions (sum, min, max, count etc.) on the data used in the Analytic View.
Steps to Create an Analytic View in SAP HANA
Here are the steps to create an Analytic View in SAP HANA Modeler:
Open SAP HANA Modeler perspective in the SAP HANA Studio.
Your pre-existing attribute views will be present within a package in the Content node.
Right-click on the package for which you need to create an Analytic View in SAP HANA which also contains the attribute views. Click on New and select Analytic view from the drop-down list.
Enter the technical name of the view and add a description. You can set other properties as well, like view type, subtype etc. Click on Finish.
The design view for the analytic view in SAP HANA Modeler opens.
From the semantics section, you can access the columns, view properties, hierarchies and variables or parameters.
Now its time to add tables into the Data foundation. You can add the data tables from the left panel either by dragging and dropping or by searching the table’s name, Add Objects icon.
If you have more than one table selected, then you need to define a join condition and cardinality. Here, in the image shown below, we have selected join type as inner join and set cardinality as 1: N in the join created two tables ORDERS and ORDERDETAILS.
Next, we have to select columns for output from both tables by clicking on the grey dots given in front of each column of the table which will turn orange as a sign of being added into the output.
Now we will go to the “start join” section to link all the attributes views with the data foundation (fact table). As you can see in the image below, we have selected three attribute views in the Star Join section; AT_CUSTOMER, AT_PRODUCTS and AT_TIME.
Three separate tables for the three attribute views will get add in the editor pane.
We will join the fact table with the attribute view table with common columns, as shown in the image below. We have joined the two tables (fact table and attribute view) with the column CUSTOMERNUMBER.
Also, we have defined the join type as an outer join.
We will join the two other attribute tables with the fact table in the same way. This will form a star schema like structure of tables.
Next, we’ll define measures and dimensions for the table from the Semantics section. You can tag the measure fields as measures from clicking on the columns and then on the yellow icon on the bar (indicated by the blue arrow). And similarly, tag the dimensions by selecting the attribute icon shown by the red arrow.
After assigning the measures and dimensions, save the Analytic View in SAP HANA Modeler by clicking on the green tick and execute the view by clicking on the green arrow (shown in the red box).
After validating and executing it, open the data preview section. There, the raw data from all the tables of the Analytic View in SAP HANA Modeler will get load.
From the Analysis section, you can quickly analyze the data by selecting attributes and measures to create different charts and graphs like a bar graph, Mekko chart, pie chart, scatter chart etc.