In this chapter, we have taken a look at the possibilities provided to us when we create scripted calculation views in SAP HANA. We have seen that scripted calculation views can achieve exactly the same results as graphical calculation views. Scripted calculation views are created by writing code, instead of by manipulating objects on the screen. We have been introduced to the CE functions provided by SAP HANA, and have used some of these, notably the CE_OLAP_VIEW, CE_PROJECTION, CE_CALC, and CE_UNION_ALL functions to read data from an analytic view, create a projection on the data read, calculate columns on the fly, and then join data from two views together. We have seen that the results of CE functions are assigned to variables, which ...

Get Software Development on the SAP HANA Platform now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.