Skip to Content
avatar image
Former Member

HANA internal engines

Hello All,

I am novice in SAP HANA. I have got a question.

I have learnt that Attribute view runs on JOIN Engine, Analytical view runs on OLAP Engine.

Calculation View runs on CALC Engine.

Consider a scenario where I have Calculation view CA_C and I have Attribute view AT_ATT.

AT_ATT is a part of CA_C.

Now when I am calling CA_C, everything will run on CALC engine or internally first AT_ATT will run in JOIN engine, then it will feed the result set to CALC engine and then i will get result?

Thank you in advance! 😊

Happy Coding!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 06, 2015 at 12:13 PM

    Hi,

    Both Join and Calc Engines will be used in this case.

    To check this:

    Create an Attribute View and call it in Calculation View.

    Then write SQL query for calling calculation view in SQL console, then R-Click on it and select "Visualize Plan" and see which engines are being hit.

    Copying Lar's reply from :

    The Plan Operators (POPs) you find in there - represented by the boxes in the graph - are named based on a naming scheme like this:

    JE<operator_name> => Join Engine (Attribute views, plain SQL)

    BW<operator_name> => Olap Engine (Analytic views)

    CE<operator_name> => Calc Engine (Analytic views with calculated attributes, Calculation views)

    In addition check the below thread to know more about HANA engines:

    Regards,

    Vivek

    Add comment
    10|10000 characters needed characters exceeded