HANA

Introduction and Overview of SAP HANA

featured-image

Hello everyone, Now a days we hear a lot of buzz around SAP HANA and more customers planning to opt for it. What does SAP HANA mean to us? Before we go into its details, we shall first know the challenges currently faced by customers. Below are some of the major challenges faced by most of the customers with current systems: Massive growth of Data Volume Immediate results Skilled workforce Complex system landscape High Flexibility

Read More »

Different Engines in SAP HANA

featured-image

Hello Everyone, In this article I would like to explain about different types of engines we have in HANA and how each engine will process the execution of modeling objects or native sql statements at Database level. The below image shows the different engines available in HANA Database to process models execution. They are, Join Engine OLAP Engine Calculation Engine ROW Engine SQL Engine

Read More »

Introduction to Modeling in SAP HANA

featured-image

Hello Everyone, In this article I would like to give an overview about SAP HANA Modeling and the data sets/data models used for the exercises for the upcoming articles. Building an Information Model in SAP HANA makes use of the different engines available in HANA as well as the hardware innovations incorporated. The modeling objects in HANA are executed in runtime like views which means it doesn’t persist any data physically.

Read More »

Calculated Column in SAP HANA

featured image

Hello Everyone, The typical enterprise data warehouse contains three layer system with traditional RDBMS as Database. The layers are Database, Application/Processing and Reporting. Database Layer: This is where all the data is being stored. The limitation with traditional database is, It is similar to hard disk we have in our laptops, which means we can only perform read and writes on it but not calculations.

Read More »

How to create Attribute View in HANA

image17

Hello Everyone, In this article, I would like to explain about Attribute View which is one of the information in HANA and how to create it in the system. What’s an Attribute View? Attribute Views are typically created for maintaining Master Data in HANA system or we can also call it as a dimension in star schema modelling. It doesn’t store the data physically, however fetches the data from source in runtime whenever we execute this object in our system.

Read More »

SAP HANA Studio Overview

image6

Hi Everyone, In this article I would like to give you an overview about SAP HANA Studio. What’s HANA Studio? HANA Studio is an eclipse base GUI tool which is used to maintain HANA Database. Using HANA Studio, We can Manage and configure HANA Database. Create Analytical Models for Enterprise reporting. Create Development artifacts for Web environment. Debug the developed artifacts. Visualize the performance of Analytical Models and so on.

Read More »

SAP HANA – Where Used List

feature-image

Hello Everyone, We all know the importance of where used list in an enterprise system especially when it comes to system maintenance. Let’s say we want to get rid of a particular object in the system then before we can delete that we would be definitely interested to know what is going to be the impact on the system or we want to know where and all one particular object has been used in the system.

Read More »