on 08-19-2015 7:08 AM
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...
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Thanks Mahaveer Jain & Rernando Ros
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.