Search

Category

HANA

Understanding Referential Join Concept

Before dwelling into Referential Join, understanding the foundation i.e., Referential Integrity is very important. The existence of the relationship between two tables based on the presence of the primary key of the parent table is necessary to have the referential... Continue Reading →

Understanding Different Views In HANA

For data modeling in HANA, there are three types of views defined – Attribute View, Analytic View, and Calculation View. Each of these views processes the data catering to specific needs for optimal performance and workability. Attribute View: It deals... Continue Reading →

User Defined Functions

UDF or User Defined Functions are read-only functions in SAP Hana. They are not aligned with DDL and DML operations. It is one of the two logical containers used in SQLScript, the other being Procedures. UDFs are further categorized as... Continue Reading →

Cursors In Hana

Cursors are set of rows of data fetched from the database with a pointer at the current row which is defined by the iteration as the code parses through the data one row at a time. When a cursor is... Continue Reading →

Fuzzy Search – Concept

On an SAP Report selection screen, the user is expected to pass part of the material description. On executing, list of materials having a certain keyword in its description is displayed with some more related information like Stock On Hand,... Continue Reading →

Optimizing Custom ABAP For HANA

Optimizing Custom ABAP code for HANA upgrade can be visualized as a three-act structure - Detect, Optimize and Innovate. What Needs Optimization? Before HANA implementation/migration, an assessment on current code needs to be made in order to understand which objects... Continue Reading →

Code To Data Paradigm

The first thing we understand about SAP HANA is that with advanced hardware capabilities the programming model can accommodate data processing at the database level. This means all data processing developers used to do in SAP by pulling data to... Continue Reading →

Why SAP HANA? A Quick Analysis

The ideal situation for any software is that it processes instantly, as close to instantaneously as feasible. In-Memory database concept was a revolution in the field of software dealing with large databases as it has always been the biggest point... Continue Reading →

Advantages Of Column-Based Storage In SAP HANA

While in SAP HANA, both Row-based data storage and Column-based data storage is used, Column-based data storage is widely used for transactional data upon which analytical applications are implemented. This is because in Column-based data storage information is juxtaposed next... Continue Reading →

Powered by WordPress.com.

Up ↑