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
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
Hadoop App
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

9 thoughts on “SAP HANA Calculation View

  1. Ning Tong says:

    Hi expert,

    A good explanation!

    Thanks & Best Regards,
    Ning Tong

    • Kevin says:

      Hi There,

      Thank You so much for this blog. It helped me lot. I am a Technical Recruiter by profession and first time working on this technology was bit tough for me, this article really helped me a lot to understand the details to get started with SAP HANA training USA .

      Hi there, I’m trying to build a query that identifies changes on item group this year.
      I’ve got the data from table AITM and so far, the query looks like below. The issue that I’m having is that the Update Date is picking up the whole table changes (and not only the item group code changes). Like I said as a result I want to see all the items that had the item group changed in the current year. Does anyone have any idea on how to get it?
      Thank you!

      T0.”Code”, T0.”Name”, T0.”GroupCode”, T1.”GroupCode” , T0.”UpdateDate”
      FROM (select “Code”, “Name”, “GroupCode”, “UpdateDate” FROM AITM) T0
      INNER JOIN (select “Code”, “Name”, “GroupCode”, “UpdateDate” FROM AITM) T1 ON T0.”Code” = T1.”Code”
      WHERE T0.”GroupCode” T1.”GroupCode” AND
      DAYS_BETWEEN( T0.”UpdateDate”, CURRENT_DATE) <= 80

      Anyways great write up, your efforts are much appreciated.


  2. ram says:

    Hi Admin,

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


  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.


  4. kiranveeruru says:

    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?

  6. Rahul says:

    Hi There,
    This is the most brilliant article ever! Please put the permalink part in the post. If someone didn’t comment on it I’d have no idea!

    As a SAP HANA beginner, I have few questions regarding Threads & Sample Threads.
    I have read the SAP Note “2114710 – FAQ: SAP HANA Threads and Thread Samples, HA200, SAP Administration Guide & Troubleshooting and Performance Analysis Guide
    but I still don’t understand what a thread and thread sample is.

    Thread samples are regular samples of thread activities which are historicized.

    Q1. What does that mean ? Could you define exactly what is a thread and what is a thread samples ?
    What I understood : Threads are an Unix feature that lets application logic be separated into several concurrent execution paths. This feature is useful when complex applications have many tasks that can be performed at the same time.
    When Unix executes an instance of HANA, it creates a unit called a process (at OS level) to manage the instance. All HANA processing takes place in Index Server. (it is one process at OS level)
    The process has a thread of execution. This is the series of programming instructions performed by SAP HANA.

    Q2. If they are so many thread in SAP HANA. What are the associated processes ?Can I see it with ps -ef at OS level ?

    On my SAP HANA System, I have seen the following tables but I don’t understand the difference between each of them.


    Q3. Could you explain the goal of these 4 tables ?

    I have read that SYS.M_SERVICE_THREAD_SAMPLES has a very short retention 2 hours contrary to _SYS_STATISTICS.HOST_SERVICE_THREAD_SAMPLES (42 days according SAP Best Practices) but i’m not sure if it is the only difference.

    Q4. What the difference between M_* tables and HOST_* tables ?

    I’m not sure to understand the link between executing the query “SELECT * FROM M_LICENSE” and the thread.

    Q5. Can I see how much memory & CPU is consumming this query into one of these 4 tables ?

    Q6. How can I proceed to find the correct the Statement ID ?

    Q7. Where can I find more information about Thread Type ? In the SAP Note 2114710, they are 88 different type but the associated SAP Note doesn’t give any help to understand them.

    By the way do you have any YouTube videos, would love to watch it. I would like to connect you on LinkedIn, great to have experts like you in my connection (In case, if you don’t have any issues).
    Please keep providing such valuable information.
    Kind Regards,
    Rahul Mishra

Leave a Reply

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

Current day month ye@r *

 © 2017 :, All rights reserved.  Privacy Policy