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 we can then use in other functions, prefixing the variable name with a colon. Finally, we did a comparison of the output of our scripted view and its graphical counterpart, and saw that the view contents of both were identical.

In the next chapter...