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