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
Topic Index
+
-
SAP HANA Modeling
+
-
Spatial Processing
+
-
Predictive Analysis

SAP HANA Calculation View

In the article SAP HANA Modeling Introduction we explained the basics of SAP HANA data modeling. We also learnt how to create modeling views in Build Your First SAP HANA Model in 10 Minutes
In this article we will learn more about 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.



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


Support us by sharing this article.



Explore More
Close X
Close X

7 thoughts on “SAP HANA Calculation View

  1. Ning Tong says:

    Hi expert,

    A good explanation!

    Thanks & Best Regards,
    Ning Tong

  2. ram says:

    Hi Admin,

    We can see a option called RANK in calculation view. How to use that?

    Thanks,
    Ram

  3. venkat says:

    Hi Experts,

    This document is very useful for Beginner.
    Could you please let us know if you have PDF file on BW On HANA.

    It will be helpful to go through it.

    Thanks in advance.

    Regards,
    Venkat

  4. kiranveeruru says:

    Hi,
    This is Kiran just I started my journey to learn hana,Pls send bw on Hana PDF if available

  5. Cyrus Arjomandi says:

    I am an ABAP consultant. Is there a way to become HANA certified consultant?

Leave a Reply

Your email address will not be published. Required fields are marked *

Current day month ye@r *

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