Calculation View

1. Dimension Calculation View

Dimension calculation views are used to give context. This context is provided by text tables which give meaning to data.
For example, if a fact table or cube calculation view in a sales database only contains the customer ID, you can use a dimension calculation view to provide information such as address, name of each customer and give context meaning to the data.
Dimension calculation view does not need to be based on the single table. On the contrary, you can use them to join master data tables to each other. For example, to join Products to Product Categories.

General Properties of Views:
For each view, you can define the properties in the View Properties Tab of the Details Pane. Depending on the type of view Graphical or Script-Based Calculation View, the list of properties may vary.
The following list gives the definition of these properties.

• Data Category: For calculation views, determines whether the view supports multi-dimensional reporting.
• Base Attribute View*: For a derived Attribute View, identifies the source Attribute view from which it is derived.
• Apply Privileges: Specifies the type of Analytic Privileges (Standard or SQL) to apply when executing a view.

2. Working with Measures in Calculation View

Cube/Cube with Star Join Calculation View

You have created a Dimension calculation view and understood the main concepts of node, data sources, output columns, semantics and so on.

You are now ready to model Calculation view that include the measures by creating CUBE with star join calculation view.

In SAP HANA, there are two types of graphical objects that handle measure:

• Calculation Views of type CUBE
• Calculation Views of type CUBE with Star Join

This second one replaces the former Analytic Views, which are now deprecated, though still supported.

Overview of the possible node types

A Calculation view can use as many nodes as you need. Each node has its own capabilities and behavior:

• Projection: To filter data or obtain a subset of required columns from a data source.
• Aggregation: To summarize measures by grouping them together by attribute columns values.
• Join: To query data from two or more data sources.
• Union: To combine data from two or more data sources.
• Star Join: To join attributes to the very last step of a CUBE with Star Join Calculation View.
• Rank: To order the data for a set of partition columns and select only the top 3/4/.../n elements.