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 […]
Tag Archives: sap 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 […]
SQL script complete tutorial – Part 7
Core SAP HANA SQL script concepts- SQL UPDATE,DELETE,DROP Welcome to the seventh installment of this SAP HANA SQL Scripts core concepts section where we learn how to manipulate data using SQL UPDATE, delete certain data using SQL DELETE and obliterate the table from existence using SQL DROP statement. Till now, we have learnt the INSERT which […]
SQL script complete tutorial – Part 5
Core SAP HANA SQL script concepts- String Functions Welcome to the fifth installment of this SAP HANA SQL Scripts core concepts section where we try to understand how to use different string functions and operators to manipulate character data sets. The String manipulation begins… It’s now time to pick up the EMP_NAMES table which contains the first name and […]
SQL script complete tutorial – Part 2
Core SAP HANA SQL script concepts- SELECT with SQL WHERE conditions Welcome to the second installment of this SAP HANA SQL Scripts core concepts section where we try to understand the SQL WHERE condition and different ways of using it. SQL WHERE – Because we only take what we need Most times when we do […]
Graphical Calculation View: Part 1
Understanding a Graphical Calculation View in SAP HANA Hi everyone and welcome to the most important tutorial in this series where we learn how to create a graphical calculation view. Calculation views form the primary core reporting data model which is developed in SAP HANA. Some of you who have already done some kind of […]
Loading data using INSERT statement into SAP HANA Table
SAP HANA SQL Script INSERT Welcome to the next tutorial explaining the usage of SAP HANA INSERT statement to insert new records into a HANA Table. This method can be applied on any table, no matter how it was created – Graphically ,by SQL CREATE or HDB Table To start, we need the SQL editor. Click somewhere […]
Loading data from flat file to SAP HANA
This beginner tutorial explains how a flat file or CSV file can be loaded to SAP HANA graphically without any coding whatsoever.
Creating a HANA Table – HDB Table Method
This beginner tutorial explains how to create an SAP HANA table using the new HDB Table method as a development object with an example.
SQL Union Types in SAP
This checkpoint tutorial focuses on understanding the SQL UNION and SQL UNION ALL statements in SAP with a simple example.
