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 […]
Author Archive: shyamuthaman
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 […]
Graphical Calculation View: Part 2
Graphical Calculation View Nodes – JOIN Continuing the build of our first graphical calculation view, we repeat the same process for VBAP to be added to Projection 2. Also, some of the fields we need from this table are also selected. At this point, these are two individual tables floating in space with no interaction […]
SAP HANA filters in Graphical View: Part 3
Filters:Type 3- SAP HANA Input Parameters Input parameters are the magical underappreciated providers of flexibility in SAP HANA. They are somewhat similar to variables but are available at every node in the view. Input parameters are of great importance and have multiple applications but here we learn how to use it as a dynamic filter at […]
SAP HANA filters in Graphical View: Part 2
Filters:Type 2- SAP HANA Variables Welcome to the second part of the graphical view filters tutorial. In this one, we try to understand how SAP HANA Variables can help us create dynamic filters to allow more flexibility in development. If a dynamic filter needs to be applied after all results have been calculated (top-level filter) , […]
SAP HANA filters in Graphical View: Part 1
Filters:Type 1- SAP HANA Constant Filters SAP standard tables may contain millions of data records and it becomes critical to the report performance that we only pull the data we need from the tables we look at. Without filters in SAP HANA, pulling up excess data can lead to slow reports, put strain on the […]
SQL script complete tutorial – Part 9
SAP HANA SQL script concepts- SQL JOIN, UNION, UNION ALL Welcome to the final installment of this SAP HANA SQL Scripts core concepts section where we learn how to pick up related data from different tables using SQL JOIN. We also learn the concept of combining data sets using the SQL UNION whilst understanding the difference between […]
