Creating calculation views

Calculation views are more advanced models in SAP HANA that are defined when requirements cannot be met with attribute and analytic views. For example, with calculation views, we can extract the required measures from more than one transaction table in the result, which is not possible with an analytic view. As well as this feature, we can define calculations at different layers and also use advanced SQL logic in calculation views. We can create joins, projections, unions, and aggregations in calculation views. This recipe explains how to create different types of calculation views.

Getting ready

Calculation views can be created in two ways:

• Using GUI (Graphical User Interface)

• Using SQLScript (native SQL or CE functions)

Any combination of the following objects can be a part of the calculation view data foundation:

• Tables

• Column views

• Attribute views

• Analytic views

• Calculation views

We can create the following objects while defining a calculation view:

• Attributes

• Measures

• Hierarchies...