Skip to Content
avatar image
Former Member

When to use a graphical CV in SQL Engine

Hi,

Can anyone help me When to use a graphical CV in SQL Engine or when in normal mode.

Sometimes it takes a long time to execute and sometimes it executes quickly in SQL engine.

-

Thanks,

Subhash

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 29, 2014 at 11:18 AM

    Hi Subhash,

    Please refer SAP Note 1857202 SQL Execution of calculation views and read the attached PDF.

    An excerpt  from the attached document:

    "When the “Execute in” property is switched to “SQL Engine” (Enforce SQL Execution) in a graphical Calculation Model the Calculation Engine tries to generate SQL out of each node during runtime. After generating SQL for each node (if possible) the SQL statements are combined into one big SQL statement which is then passed to SQL interface. This might be beneficial as SQL interface also involves standard SQL optimizer which implements a lot more optimization rules than Calculation Engine. E.g., most important rule is join ordering determination.

    This option is only efficient if every node can be translated so that one big SQL statement can be generated."

    Regards,

    Vivek

    Add comment
    10|10000 characters needed characters exceeded