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

4 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

  • Nov 05, 2018 at 06:15 AM

    Hi Jyoti,

    The recommendation is now to use a table function within a graphical calculation view instead of old scripted format. That will still allow you the scripting freedom that you're after should you wish to do so.

    You can easily migrate your scripted calculation view to a table function using the following steps:

    • Go into HANA Studio and change to the SAP HANA Modeler perspective
    • Open up the Quick View and select Migrate
    • Select the system you are working on
    • Then choose “Script-based calculation views to graphical calculation views and table functions”
    • Choose the scripted view you want to migrate and add to right
    • It will add it to your repository to activate (in same content package where your scripted calculation view resided) and once active will appear in the _SYS_BIC schema.

    You can now use this table function in a select clause just like you would do with a table or view:

    select * from"_SYS_BIC"."system-local.private.dorothy8::TABLE_FUNCTION_CV_FINANCE_LEDGER_DEMO"()

    AND you can use it within a calculation view for it to be exposed to BI reporting tools.

    Hope this helps.

    Kind regards,

    Dot

    Add comment
    10|10000 characters needed characters exceeded