SAP HANA Scripted Calculation View input parameters Welcome again to our next tutorial. You’ve already learn about dynamic filtering on the output of a calculation view using variables in our previous tutorial. This tutorial deals with another type of dynamic filtering – SAP HANA Scripted Calculation view input parameters. These dynamic filters, based on user […]
Author Archive: shyamuthaman
SAP HANA Scripted Calculation View -Variables
SAP HANA Scripted Calculation View variables Welcome to the new tutorial on SAP HANA scripted calculation view variables. When the filters need to be applied after the end of execution of the entire logic in a dynamic manner, variables are used. This means that when you apply a variable filter on a field, there will be […]
SAP HANA Scripted Calculation View – Filters
SAP HANA Scripted Calculation View Filters Welcome again to the next SAP HANA Scripted Calculation View tutorial series. In this one, we learn how to use SAP HANA Calculation view filters, SAP HANA Variables and SAP HANA Input Parameters. This is the first tutorial in this series and will focus just on SAP HANA Calculation […]
SAP HANA Scripted Calculation View Step 3
SAP HANA Scripted Calculation View – Part 3 In real time projects, usually this scripted calculation view is the base for building reports. The reporting team can have a hard time understanding these field names. To be honest the HANA development team wouldn’t know the descriptions of most of them too. Before we start, as a […]
SAP HANA Scripted Calculation View Step 2
SAP HANA Calculation view using SQL script – Part 2 Welcome to the second part of the tutorial introducing SAP HANA Calculation view using SQL script . If you’ve landed directly on this page, I recommend starting from the first tutorial for better understanding. Now, as per our original requirement, we would need a view consisting of a […]
SAP HANA Scripted Calculation View – Step 1
SAP HANA Scripted Calculation View – Part 1 At this point starts the most important parts of the HANA SQL Tutorial series. The SAP HANA scripted calculation view is used to code the logic required in SQL. Usually, this is done whenever the logic was too complicated to be achieved by the nodes available in Graphical […]
Analytic View
Legacy: SAP HANA Analytic view Welcome back fellow learners to our SAP HANA Tutorial where we would learn about SAP HANA Analytic View. These are the third type of HANA information views we would be learning after Calculation views and Attribute views which we have gone through already. Note: Analytic views, just like attribute views are […]
Attribute view
Legacy: SAP HANA Attribute view Welcome folks to the Attribute View in SAP HANA tutorial. In this tutorial, we learn the second type of view that can be created called the attribute view. We have been creating calculation views till now. Note: Attribute views are no longer recommended to be used in development. Calculation views […]
UNION Node in SAP HANA Calculation View
SAP HANA Union node in Calculation view Welcome back to the next in line tutorial on SAP HANA Union node in Calculation view. I hope you already read my tutorial on Unions SQL UNION and have a theoretical understanding of what a UNION is. The funny fact about this UNION node here is that it’s […]
Rank in SAP HANA Calculation View
Rank node in SAP HANA Calculation view Welcome to the next tutorial of this SAP HANA Tutorial series. In this one, we learn how to rank rows and pick up the highest or lowest ranks according to a condition using the Rank function in calculation views. Let’s get into the requirement. In a company XYZ, […]
