You are Here: :/HANA
HANA 2017-07-27T01:01:26+00:00

Loading Data to SAP HANA – Using SLT

By | September 11th, 2015|HANA|

Hello Everyone,                 Data can be loaded from any source system to target system through many ways. This process of data loading is generally coined as DATA PROVISIONING. In HANA too, we have many data provisioning options. Here are the list of data provisioning techniques often used for HANA as [...]

Calculated Column in SAP HANA

By | June 10th, 2015|HANA|

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 [...]

SAP HANA – Calculation View using SQL Script

By | September 30th, 2015|HANA|

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 [...]

SAP HANA – Classical Analytic Privileges

By | September 23rd, 2015|HANA|

Hello Everyone, Data Security/Restriction depending on the user logged into the system is one of the integral part of any data warehousing system or reporting solution. In this article we are discuss about the process of data security in SAP HANA. The data security on HANA modeling objects can be [...]

Introduction to Modeling in SAP HANA

By | June 16th, 2015|HANA|

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 [...]

BW Modeling tools installation in SAP HANA

By | August 4th, 2015|BW, HANA|

Hello Everyone, In this article, let’s see how to install BW modelling tools in SAP HANA Studio. These tools provide a new eclipse based modelling platform IDE (Integrated Development Environment), which helps to integrate SAP HANA modelling with BW providers(Open ODS , Composite providers etc) through a power user Interface [...]

SAP HANA – Restricted Column/Measures

By | August 11th, 2015|HANA|

Hello Everyone, In this article, we would like to explain about one of the feature available in Analytic View/Calculation View which is Restricted Column/Measure. What is Restricted Column? Restricted Column is an additional measure created based on Attribute restrictions. Example: Business wants to have additional column for Sales Amount based [...]

SAP HANA Decision Tables – With Return Values

By | October 9th, 2015|HANA|

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. […]

Skip to toolbar