Creating calculation views
Calculation views are composite views that are used to calculate complex tabular results using either explicit SQL script code or a data flow graph that is visually created in the SAP HANA Studio. It can consume other analytical/attribute/calculation views and tables. It can perform complex calculations that are not possible with other views.
The calculation views are of the following types:
Graphical calculation views are created using the graphical editor
Scripted calculation views are created using the SQL editor
Complex calculations, which are not possible through the graphical approach, can be created using SQLscript. Calculation views can be used in the same way as analytic views.
In contrast to analytic views, it is possible to join several fact tables in a calculation view where measures are selected from the different fact tables.
We will use the standard EPM data that is given as IDES data in SAP HANA. Our calculation view would be for sales orders from two...