Calculation Views: Graphical vs. Script

[jannis]

Hello,

As we all know Calculation views in SAP HANA Cloud and SAP Data Warehouse Cloud can only be Graphical but to be honest I miss script calculation views. Personally I find it really useful to check the SQL code in a single place rather than having to click in multiple joins, unions and so on and have code scattered around.

What's your views on that? Do you prefer Graphical or Script?

Best Regards,

Ioannis

[Cocquerel]

Hello,

you can use table function (.hdbfunction, see https://help.sap.com/viewer/3823b0f33420468ba5f1cf7f59bd6bd9/2.0.06/en-US/cbf136986c98430ea50ddf4b95... ) as alternative to Script Calculation Views.
Personally, I'm more confortable with SQLScript than CV Graphical Editor but graphical CV has the advantage that, whatever the statement that is done on top (selected columns, filter, aggregation, ...), the generated SQL plan has more chance to be optimized. So, if you don't know what kind of statements will be used to consume your object, graphical CV is more robust. In addition, with table function, you will miss some functionalities like Analytics privileges or data result caching,...
Regards,
Michael