Calculation views are composite views and can be used to combine other views. It can consume other Analytical, Attribute, other Calculation Views & tables.
It can perform complex calculations not possible with other views.
Calculation view can be defined as either graphical views or scripted views depending on how they are created. Graphical views can be modeled using the graphical modeling features of the SAP HANA Modeler. Scripted views are created as sequences of SQL statements.
It can perform complex calculations not possible with other views.
Calculation view can be defined as either graphical views or scripted views depending on how they are created. Graphical views can be modeled using the graphical modeling features of the SAP HANA Modeler. Scripted views are created as sequences of SQL statements.
Types of Calculation Views:
Calculation views can be created using a Graphical editor or the SQL Script editor.
- Graphical calculation views are created using the graphical editor.
- Scripted calculation views are created using SQL Editor. Complex calculations which are not possible thru graphical approach, can be created using SQLScript.
Capabilities of Calculation Views:
Graphical Calculation Views
- Can consume other Analytical, Attribute, other Calculation Views & tables
- Built-in Union, Join, Projection & Aggregation nodes
- Provides additional features like Distinct, Count, Calculation, dynamic joins
- No SQL or SQL Script knowledge required
SQLScript-based Calculation Views
- Can be regarded as a function, defined in the HANA-specific language “SQLScript”, which is built upon SQL commands or special HANA pre-defined functions
- Must be read-only
No comments:
Post a Comment