How to put loop endloop in Graphical Calculation View in HANA studio?

[shiromani_soni1]

I have a requirement to convert ABAP code in SAP HANA Calculation Graphical View, where I am looping an internal table and calculating value of a field in each iteration of loop. In Graphical Calculation View I am not sure how to put this requirement, any help is really appreciated.

Another requirement is to put Order by on 2 columns in same Calculation Graphical View, where Rank node allows Order by on only one column.

[pfefferf · Accepted solution]

Regarding your first requirement for a loop I think depending on your calculation it might be easily solved a a calculated column. The expression of the calculated column is applied by default to each data record of the data source of a node. One comment regarding the "ABAP code conversion": Please do not try to convert your ABAP code 1:1 into HANA native objects. This will lead in most cases to performance and other issues. Try to use the new options and patterns of HANA.

Regarding the requirement to use two columns for ordering in a rank node it has to be said that in the graphical tools only one order column is supported at the moment. An option to use two order by columns would be, to use a table function as data source, in which you implement the "rank node" functionality by yourself using Window Functions.

Regards,
Florian

[shiromani_soni1 · Accepted solution]

Hi Florian,

Thank you for your answer on this. Could you please explain more about Windows Functions or how to use them in HANA studio??

Any example will really help in this.

Regards.

Shiromani Soni

[pfefferf · Accepted solution]

In my answer the official documentation for Window Functions is linked. There you can find all information about it and examples. You can also check the videos of the SAP HANA Academy regarding Window Functions (e.g. SQL Window function: Rank).

Regards,
Florian