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) ...
Get SAP HANA Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
