cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

Thank you for the info Fernando.


Regards,

Mahaveer Jain

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks Mahaveer Jain & Rernando Ros

Former Member
0 Kudos

Hi,

Please do mark the answers as helpful or correct and close this thread.

Thanks,

Mahaveer Jain

former_member182114
Active Contributor
0 Kudos

HI Colleagues,

There's a lot of documentation of HANA, a good part of it points to Analytic, Atribute.... bla bla but this is from the fundation of HANA.

Currently what the newer revisions of HANA aren't enhancing such artifacts.

The graphical modeling found on calculation view are heading to be the unified interface for all needs (except SQL coding).

Currently you can model star schemas on calculation graph views, you can model graph and run into SQL engine.... Web based development also support model only this artifact.

Regards, Fernando Da Rós