Skip to Content
-1

How Scripted Calculation View executed internally in HANA memory

Oct 09, 2017 at 09:30 AM

117

avatar image

Hi Experts,

SAP has recommended to use Graphical calc view instead of scripted calculation view. Could anyone explain why Scripted calculation view is obsolete. And how Scripted calculation view converted inside the HANA memory.

Regards,

Jyoti

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member
Oct 09, 2017 at 12:43 PM
0

Hi Jyoti,

for reasons of performance. Because the sql engine is now optimized for calculation views. When you work with scripted view you are “too free” in modeling, you may get problems with the performance during execution. Also in script-based calculation views, the WHERE clause will not be pushed down

Best Regards Thorsten

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Thorsten

For which scenarios is a row engine invoked?

0

"where clause is not pushed down" means even you have where condition in your script based view, it is still not pushed down ? So all queries are read first and later on it is filtered ?

0
Jyoti Senapati Oct 11, 2017 at 05:30 AM
0

Hi Thorsten,

Thanks for the response.

You have mentioned that "too free" in modeling, This point I am not getting.

Actually I need to know which all engines of HANA comes in the scenario when a scripted calculation view executed in HANA.

Regards,

Jyoti

Share
10 |10000 characters needed characters left characters exceeded
Jyoti Senapati Oct 11, 2017 at 05:30 AM
0

Hi Thorsten,

Thanks for the response.

You have mentioned that "too free" in modeling, This point I am not getting.

Actually I need to know which all engines of HANA comes in the scenario when a scripted calculation view executed in HANA.

Regards,

Jyoti

Share
10 |10000 characters needed characters left characters exceeded