SAP HANA Calculation View notes

[Former Member]

Hi Experts,

Please share notes for CREATING CALUCLATION VIEW USING SQL Script. If possible please share SQL Script example and how to use it.

Thanks

Pawan

[Former Member]

Hi Pawan,

You want to create calculation view base on sqlscript, firstly, you choose one package of content, and right-click "new" icon, and choose "calculation view" item.

Notes, you choose "sql script" for view type, by this way you can create calculation view base on sql script.

You can write you procedure between "begin" and "end" body, you can define input and output parameter on right perspective.

simple example sql:

var_out = select now() as "TimeStamp", 1 as "Num" from dummy;

you need to define two output parameter for var_out table type, TimeStamp VARCHAR(30)/Num Tinyint.

finally, you define "TimeStamp" as attribute and "Num" as measure for calculation view, and save and active your calculation view.

Hope this can help you.

Regards,

Jerry