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, […]

Aggregation Node in SAP HANA Calculation View

Aggregation node in SAP HANA Calculation View Welcome again good folks to the next SAP HANA tutorial where we learn about the humble Aggregation node in SAP HANA. An aggregation node is usually attached to the semantics node by default if you are building a transaction calculation view(This means that the data category CUBE was […]