SapHanaTutorial.Com HOME     Learning-Materials Interview-Q&A Certifications Quiz Online-Courses Forum Jobs Trendz FAQs  
     Explore The World of Hana With Us     
About Us
Contact Us
 Apps
X
HANA App
>>>
Hadoop App
>>>
Tutorial App on SAP HANA
This app is an All-In-One package to provide everything to HANA Lovers.

It contains
1. Courses on SAP HANA - Basics, Modeling and Administration
2. Multiple Quizzes on Overview, Modelling, Architeture, and Administration
3. Most popular articles on SAP HANA
4. Series of Interview questions to brushup your HANA skills
Tutorial App on Hadoop
This app is an All-In-One package to provide everything to Hadoop Lovers.

It contains
1. Courses on Hadoop - Basics and Advanced
2. Multiple Quizzes on Basics, MapReduce and HDFS
3. Most popular articles on Hadoop
4. Series of Interview questions to brushup your skills
Apps
HANA App
Hadoop App
';
Search
Stay Connected
Search Topics
Course Index
Close
X
SAP HANA Basics
Course Overview
1. Introduction to SAP HANA
2. SAP HANA Architecture
3. SAP HANA Studio
4. SAP HANA Modeling
5. Reporting on SAP HANA
6. What is Next?
<< Previous
Next >>

4.9 Overview of Calculation View

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.

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

Click here to go to Next Chapter.

Connect to The SAP HANA Forum to ask any question, provide feedback or share information.

 © 2017 : saphanatutorial.com, All rights reserved.  Privacy Policy