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

Calculated Measure in SAP HANA

By | August 6th, 2015|HANA|

Hello Everyone, In this article, let’s look at one of the advanced feature available in Analytic Views and Calculation Views in SAP HANA i.e. Calculated Measure. Unlike RDBMS where we cannot perform any calculations at database level, using SAP HANA which is in-memory database we can push all the calculations [...]

SAP HANA Reporting – Connectivity Options

By | October 11th, 2015|BOBI, HANA|

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

SQL DateTime Functions in SAP HANA

By | July 1st, 2015|HANA|

Hello Everyone, In any Data warehousing system, one of the main objective is to transform the source data into meaningful information which can be easily understand and analyze by business. In order to achieve this we need to have knowledge on the different functions available at database level and how [...]

SAP HANA Calculation View – Filter Expression

By | September 30th, 2015|HANA|

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

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

SAP HANA – Introduction to Data Provisioning

By | September 23rd, 2015|HANA|

Hello Everyone, In this article, we will be discussing about the different data provisioning techniques available for SAP HANA. When we built Data Warehousing system with SAP HANA centric, it is very important to have a clear idea on different data provisioning techniques available. For HANA, we can divide the [...]

SAP HANA Calculation View – CE Functions

By | September 30th, 2015|HANA|

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

Temporal Join for time dependent data in SAP HANA

By | August 11th, 2015|HANA|

Hello Everyone, In this article, we are going to discuss about how to build models in HANA for time-dependent data with the help of temporal join available in Analytic View. What is Temporal Join? Temporal joins are used to join the master data with the transaction data (fact table) based [...]

SQL String Functions in SAP HANA

By | June 24th, 2015|HANA|

Hello Everyone, In any Data warehousing system, one of the main objective is to transform the source data into meaningful information which can be easily understand and analyze by business. In order to achieve this we need to have knowledge on the different functions available at database level and how [...]

Skip to toolbar