SAP HANA: using SQL for graphical views’ analysis

SAP HANA: using SQL for graphical views’ analysis

SAP HANA
In general, SAP HANA’s objects can be built using two different approaches: SQL language (SQL views, table functions, procedures); Graphical Blocks (graphical calculation views). Usage of graphical calculation views has some advantages (comparing to SQL objects): they are easier to maintain, the flow is more obvious and easy to understand, additionally it’s more convenient to change them and it’s very simple to show data in the intermediate steps (data preview option). On the other hand, using SQL objects gives the ability for an easy extension of the code in the console – you can always take part of SQL code, copy it to the console, modify, run and check the results. Fortunately, the same approach can be used together with graphical view – there is an SQL object behind every…
Read More