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

SAP HANA – Generate Time Data

By | August 27th, 2015|HANA|

Hello Everyone, In this article, we are going to look at the details of ‘Generate Time Data’ option available in ‘Quick View’ screen when we are in ‘SAP HANA Modeler perspective’ of HANA Studio. What is Generate Time Data? Almost all the time, business wants to analyze their data sets by [...]

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

Quick View screen for Modeler in SAP HANA (Part 2)

By | August 27th, 2015|HANA|

Hello Everyone, In this article, , we are going to discuss about the activities that can be performed with the help of ‘Quick View’ screen available in SAP HANA Studio modeler perspective. This particular screen will be very helpful for modelers to perform some of import tasks easily and quickly. [...]

SAP HANA – Distinct count using counter

By | August 11th, 2015|HANA|

Hello Everyone, In this article, lets look at how to calculate distinct count for any attribute(column) in HANA with the help of one of the new feature available ‘Counter’. Senario: Business want to identify what is the count distinct products brought by each customer. Solution: In this kind of requirement, [...]

Difference between Variable and Input Parameter in SAP HANA

By | August 11th, 2015|HANA|

Hello Everyone, The two features we have in SAP HANA when we need to capture user input during runtime or while executing information views are Variable Input Parameter But most of us are often left puzzled as what is the difference between these two is and when to use them. [...]

SAP HANA – Privileges required by a business user

By | September 23rd, 2015|HANA|

Hi Everyone, Most of the times we would be wondering what are the privileges that a business user need in SAP HANA. The most frequent question we often face from business, when we start creating users in SAP HANA is, each business user should see only few modeling objects (restricted [...]

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

Loading Data to SAP HANA – From Flat file

By | September 11th, 2015|HANA|

Hello Everyone, One of the advantages we have with SAP HANA studio is, we have an option to load data from either .csv or excel files to SAP HANA database directly without using any of the ETL tools like SAP Data Services or Informatica and so on. In this article, we will [...]

SQL Functions for Calculated Column in SAP HANA

By | July 7th, 2015|HANA|

Hello Everyone, In this article, I would like to explain the different SQL Functions available while creating calculated column in SAP HANA which is available in Attribute View, Analytic View, Calculation View and Decision Tables. Conversion Functions String Functions Mathematical Functions Date Functions Miscellaneous Functions Please go through the below [...]

Skip to toolbar