HANA internal engines

[Former Member]

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!!

[vivekbhoj · Accepted solution]

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