Different Types of HANA Modeling Views

A basic understanding how SAP HANA processes views is required so that you can ensure that data transfer within the database system is minimized.

Attribute Views
Attribute views are used to define joins between tables, and explain to the system a reasonable way
for these joins to be undertaken. They can also be used to select a subset of columns and rows from
a table.
One application of attribute views is to join multiple tables together to create a single dimension
table when using star schemas. The resultant dimension attribute view can then be joined to a fact
table via an analytic view (see below) to bring meaning to its data. For example attribute views can
be used to join employees to organizational units which could then be joined to a sales transaction
via an analytic view.

Analytic Views
Analytic views are typically defined on at least one fact table that contains transactional data. Using
analytic views you can create a selection of measures (sometimes referred to as key figures), add
attributes and join attribute views.

Analytic views leverage the computing power of SAP HANA to calculate aggregate data, e. g. the
number of sold cars per country, or the maximum power consumption per day. They are defined on
at least one fact table, i. e. a table which contains e. g. one row per sold car or one row per power
meter reading, or more generally speaking, some form of business transaction records. Fact tables
can be joined to allow access to more detailed data using a single analytic view. Analytic views can be defined on a single table, or joined tables.

Analytic views can contain two types of attributes (or columns), so-called measures and key figures.
Measures are attributes for which an aggregation must be defined. If analytic views are used in SQL
statements (see below) then the measures have to be aggregated e. g. using the SQL functions
SUM(<column name>), MIN(<column name>), or MAX(<column name>). Normal attributes can be
handled as regular columns. For them there is no need to be aggregated.

Analytic views model the structure of a star schema and can access dimension tables to filter or label
data from the . N.b. Analytic views can directly access fact tables without the need

Calculation Views
Calculation views are used to provide composites of other views. Essentially they are based on a join
or union of two or more data flows or invoke built-in or generic SQL functions

Tags: HANA Views, HANA Modeller View Architecture, HANA Calculation Views, Analytic Views,  how SAP HANA processes views, Attribute Views,
Share this article :

Post a Comment

Copyright © 2011. SAP HANA TUTORIALS FREE - S/4 HANA - All Rights Reserved