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