Core SAP HANA SQL script concepts- Calculated fields and Alias Welcome to the third instalment of this SAP HANA SQL Scripts core concepts section where we try to understand how to create new calculated fields and how to rename field names using SQL alias concept. Now let’s play with transaction data for a while. Let’s see how data […]
Tag Archives: hana training
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 […]
SQL script complete tutorial – Part 1
Core SAP HANA SQL script concepts- SELECT STATEMENT Welcome to the next series of tutorials on SAP HANA SQL script which will aim at making you comfortable with the SQL side of SAP HANA. Most of us are scared of coding but let me assure you that you can pick it up fairly easily if […]
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 […]
Linking HDB tables to Flat files
Import flat file(CSV) with HDB Table – Table Import Configuration Welcome again to the next tutorial where we learn how to link a CSV file to an HDB table. This is the third and last part of the data load to HANA table tutorial series. This method only works with HDB Tables. Although this is […]
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.
Creating a HANA Table – SQL Script Method
This beginner tutorial explains how to create an SAP HANA table using the SQL script method with an easy to understand example.
Creating a HANA Table – Graphical Method
This beginner tutorial explains how to create an SAP HANA table using the graphical method without any use of codes 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.