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.

Semantics Information

• 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.

Click here to go to Next Chapter. 4.8 Build Your First Analytic View