O'Reilly logo

SAP HANA Cookbook by Ganesh Mahadevan V., Chandrasekhar Mankala

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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) ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required