Chapter 6. You Talking to Me? – Scripted Calculation Views

Writing actual code is not something we've had to do yet with SAP HANA; we've been using the graphical modeling tools provided in the Studio. This is one of the strong points of the system. Writing SQL code in itself is relatively easy. It doesn't take much training to be able to write a simple SELECT statement. After a couple of tries, we can add a JOIN or two, GROUP BY, ORDER BY, and we think that we've mastered everything SQL has to offer.

The truth of the matter is, of course, very different. Writing complex SQL is DIFFICULT. Writing a large SQL instruction to do half of what the graphical calculation view we built in the previous chapter can do, without bringing the machine to its ...

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.