Calculation View In SAP HANA

Introduction

SAP HANA, or “High-Performance Analytic Appliance,” refers to a database management system and application platform that uses in-memory technology. SAP HANA is a well-liked option for businesses looking to speed up their decision-making processes because it is built to manage enormous volumes of data and perform real-time data processing and analytics.

First, let’s see what’s a view in general

A view is a kind of imaginary table that will have the results linked to the SQL statement. Note that the data from the SQL query need not come from a common database table.

Execution management by HANA Graphical Calculation View

SAP HANA, An appliance with set of unique capabilities has provided wide range of possibilities for end user to perform data modeling. One among them is 'Graphical Calculation View', which helps in leveraging the fullest potential of SAP HANA in data modeling sector.

This Document helps in understanding the nature of execution management by HANA Graphical Calculation Views by utilizing the allowed set of properties in it. So as to reveal out the effectiveness in handling the properties to manage the execution flow.

First among the property set under discussion is

Computing rates using SAP HANA calculation view

When using SAP HANA for analytical purposes, it is interesting to have rates (interest, participation, benefit, etc) being computed by HANA, instead of BI tools, for performance reasons. It is very easy to use a calculation view to compute those rates.

Let's take an example the following calculation view, which is using one analytical view (called SALES) and one attribute view (called PRODUCT). There is a join in between the 2 views on PRODUCTKEY, and some objects have been added to output. I want to compute the benefit between the SALESAMOUNT and the TOTALPRODUCTCOST as a rate, the formula would be SALESAMOUNT/TOTALCOST*100 (to get a percentage) so I added the BENEFIT to the output of the JOIN; well this is a MISTAKE, let's see why!

Getting the Counters right with stacked Calculation Views

Data Modeling in SAP HANA provides great amount of flexibility to the end user. One of the key capabilities in Modeling sector of SAP HANA is computation of user required calculations. One of the variations in calculation which end user can perform in Calculation Views/Analytic Views is 'Counter'.

Let us now understand the operations under the hood when stack of Calculation Views are created in a project.

Consider a simple 'Product Details' table which comprise of the product information along with its sales information as shown below:

Product	Store	Customer	Quantity	Revenue	Unit
Headset	METRO	ALDI	2	120	PACKG
ipad	METRO	ALDI	10	6000	PACKG
ipad	METRO	IBM	10	6000	PACKG
Budweiser	EDEKA	IBM	360	720	BOTTL
Coke	EDEKA	ALDI	260	390	BOTTL
Coke	EDEKA	IBM	250	375	BOTTL
Coke	EBAY	IBM	200	300	BOTTL
Headset	EBAY	IBM	10	600	PACKG
ipad	EBAY	ALDI	10	600	PACKG