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 […]
Category Archives: Uncategorized
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 […]
Restricted Column
Restricted column in SAP HANA Welcome to the next tutorial in this series where we learn how to work with the concept of Restricted columns in SAP HANA. Just as the name suggests, a restricted column is a user created column that is restricted in it’s output by a condition that we specify. For example, if […]
Calculated Column
Calculated column in SAP HANA If you have made it this far into the tutorial, I commend your will to continue striving to be the best in SAP HANA. This website will continue to focus on teaching you everything that you need to know to be an excellent SAP HANA consultant. Moving on, this tutorial […]
