Advantage of CE functions

[Former Member]

Hi all

what is the advantage of using CE functions in calculated view ?

I read in one of the pdf that performance would be better and recommended ..why ?

can you please clarify it as I am new to HANA?

THANK YOU

[former_member184768 · Accepted solution]

Hi Hari,

These functions are executed by the Calculation Engine directly hence provide better performance. Although these function do not provide high degree of flexibility as compared to SQL statements, but from performance perspective these are much better optimized.

Regards,

Ravi

[Former Member · Accepted solution]

thanks ravi & vijay..

very helpful

[former_member672336]

Hi Hari,

Using CE functions in calculation view is basically for better performance when we deal with complex calculation since the client quries can be well optimized and parallelized in CE functions. Always advised to use CE functions when create sql script based Calculation view. Please find below some CE functions for your reference.

CE_COLUMN_TABLE-Provides access to an existing column table, returns the table content bound to a variable.

CE_JOIN_VIEW - Returns the result for an existing join view.

CE_OLAP_VIEW - Returns the result for an existing OLAP view.

CE_CALC_VIEW -  Returns the result for an existing Calculation view.

like we have CE_LEFT_OUTER_JOIN, CE_RIGHT_OUTER_JOIN, CE_PROJECTION, CE_AGGREGATION, CE_UNION_ALL....provides many CE functionas available for the better performance.

Hope it helps you.

Regards

Vijay