Why should we create Calculation view in Hana Modeling..?

[Former Member]

Hi,

I'm new to SAP Hana Environment.

We create Attribute view when we have master data or dimensions and we create Analytical view when we have transaction data or fact table.

Why should we create Calculation view..? What is the purpose of creating?

While searching I'm not getting proper answer and I'm get how to create calculation view only.

Could anyone please clarify my doubt...

[Former Member · Accepted solution]

Hi Naga,

Calculation views is to do the complex calculations that cannot be achieved by Analytic views alone.

There are complex functions that are available in Calculation views that make execution quiet easy.

These are the complex CE functions which we use.

note: that there are separate engines for Analytic views and Calculation views and if you use a calculated column in an Analytic view then that gets executed in the calculation engine and not the OLAP engine of Analytic view.

These separate engines add to the capability expansion of execution of HANA.

for more understanding go through this, read the views part

Hope this answers your question.

Regards,

Mahaveer Jain

[former_member182114 · Accepted solution]

Hi Mahaveer,

Mahaveer Jain wrote:

Calculation views is to do the complex calculations that cannot be achieved by Analytic views alone.
There are complex functions that are available in Calculation views that make execution quiet easy.

These are the complex CE functions which we use.
note: that there are separate engines for Analytic views and Calculation views and if you use a calculated column in an Analytic view then that gets executed in the calculation engine and not the OLAP engine of Analytic view.

This is not true, you can model even simple things on calculation views. If it will run into OLAP, Join Engine, CE it really depends on what you model. There's a flag also on properties which you can se the Execute In to SQL, in such case CE is not used.

Read the post and discussion on this blog Calculation Engine (CE) Functions - Rest in Peace | SCN

Best regards, Fernando Da Rós

[Former Member · Accepted solution]

Thank you for the info Fernando.

Regards,

Mahaveer Jain