Skip to Content
-1

How Scripted Calculation View executed internally in HANA memory

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 09, 2017 at 12:43 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 11, 2017 at 05:30 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 11, 2017 at 05:30 AM

    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

    Add comment
    10|10000 characters needed characters exceeded