In this chapter, we took a look at what a graphical calculation view is, how it works, and how to build one. We started by importing our two analytic views, CUST_REV and PROJ_REV, and, using projection blocks, selected those fields with which we wanted to work, and created a new field to indicate the type of data we were using. We then joined the data in the two fields together, using first a Join block, then a Union block, in order to present a single list of fields. Finally, we took the output of the union, and added our fields to the Output block of the view. Using the Studio's Data Preview function, we confirmed that the calculation view we had just built was working as we expected.

In the next chapter, we'll be learning that SAP HANA provides two ways to create calculation views – first the graphical way, as we have just seen, and secondly by using an inbuilt language, SQLScript. In order to better understand how SQLScript works and how to use it in a calculation view, we'll...