HANA

SAP HANA – SQL Data Definition Statements

Hello Everyone, In this article, we are going to look at different SQL Data Definition Statements (DDS) available in SAP HANA along with their syntaxes and examples. Different statements available in SAP HANA are,

Read More »

SAP HANA – SQL Procedural Statements

Hello Everyone, In this article, we are going to look at different SQL Procedural Statements (PS) available in SAP HANA along with their syntax and examples. Different procedural statements available in SAP HANA are,

Read More »

SAP HANA – SQL Data Manipulation Statements

Hello Everyone, In this article, we are going to look at different Data Manipulation Statements (DMS) available in SAP HANA along with their syntaxes and examples. Different statements available in SAP HANA are,

Read More »

SAP HANA Reporting – Connectivity Options

Hello Everyone, Once we have data transformed based on the business requirement in our data warehousing system, it is very important to present the data in a better way visually too, for the business who will be analyzing it day in and day out. In this article, let’s talk about different reporting tools that are certified to be connected to SAP HANA Database (models and tables) from SAP and the languages and client drivers it uses to interact with the database system.

Read More »

SAP HANA – Sample Dataset

Hello Everyone, We always believe, it is easy to remember the things better when we actually work on system rather than just reading the concepts. This is one of the reason why we have created ‘Introduction to modeling in SAP HANA’ and explained the models and tables we will be using to showcase the modeling capabilities in SAP HANA. We thought it would be even better to provide you with the table structures along with the sample dataset that we had used to build our models so that everyone can practice in their respective systems.

Read More »

SAP HANA Decision Tables – With Updated Values

Hello Everyone, In this article, we will be looking at the final modeling object that we can create in SAP HANA in modeler perspective, i.e. Decision Tables. To know more about modeling in SAP HANA and how to create different modeling objects, please go through the below articles.

Read More »

SAP HANA Decision Tables – With Return Values

Hello Everyone, In this article, we will be looking at the final modeling object we can create in SAP HANA in modeler perspective, i.e. Decision Tables. To know more about modeling in SAP HANA and how to create different modeling objects, please go through the below articles.

Read More »

SAP HANA – Calculation View using SQL Script

Hello Everyone, In this article, let’s look at Calculation View, which is one more modeling object in SAP HANA and the step by step process to create Calculation View using SQL Script. What is Calculation View? A calculation view is a powerful and flexible information view, which can be used to define more advanced logic or complex calculations on the tables or information views available in SAP HANA. Calculation Views provides us with the functionality that is available both in Attribute and Analytic View. Mostly calculation views are used when we were not able to design the business logic with …

Read More »

SAP HANA Calculation View – Filter Expression

Hello Everyone, In this article, we are going to look at one of the very useful feature available while creating calculation view in SAP HANA, i.e. Filter Expression. We know that most of the times, it is always better to filter the unnecessary data before we start applying business logic which is where we lacked with traditional database systems. With SAP HANA, we have the flexibility to filter the data at database level and it is good to utilize it to the maximum. We can apply two types of filters in SAP HANA while creating Modeling objects. They are Static …

Read More »

SAP HANA Calculation View – CE Functions

Hello Everyone, In this article, we are going to discuss about different Calculation Engine (CE) functions available in SAP HANA and how to use them. Before we go ahead and look at CE functions, we know that there are different engines in SAP HANA which are used to execute the modeling objects that we create. You can read the article ‘Different Engines in SAP HANA’ to know more about each engine. The Calculation Views we create in SAP HANA will be executed by Calculation Engine (CE) in the back ground. When SAP released HANA into the market, SAP recommended using …

Read More »