4.7 Analytic View Overview
Analytic views are fact tables surrounded by dimensions (attribute views) and hence it resembles star schema.
- In the language of SAP BW analytical views can be roughly compared with Info Cubes or Info Sets.
- Analytic views are typically defined on at least one fact table that contains transactional data along with number of tables or attribute views.
- Analytic views leverage the computing power of SAP HANA to calculate aggregate data, e. g., the number of bikes sold per country, or the maximum power consumed per month.
- It is specifically designed to execute star schema queries.
HANA Analytical Views are highly optimized for aggregating mass data.
Capabilities of Analytic Views:
- Defining Calculated & Restricted Measures
- Aggregation (sum, max, min)
- Expressions / Operators / Functions
- Currency and Unit Conversion
- Variables and Input Parameters
- Variables and Parameters are usually entered manually by the users to filter data
Analytical View – Structural Overview:
Data Foundation of Fact Data
- Create a fact table by adding and joining the tables
Logical Join with Attribute View
- Join attribute views to these tables in the Logical Join node.
- Classify the Columns and Calculated Columns as attributes and measures.
- You can also create variables/input parameters, and assign variables to the columns in the Semantics node.