Venkat N

Venkat N

SAP HANA Analytic Privileges – Classical XML Vs SQL

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 going discuss about the process of data security in SAP HANA. The data security on HANA modeling objects can be done with the help of Analytic Privileges. What is an Analytic Privilege? Analytic Privilege is used to restrict accessing of entire data present in information models (modeling objects) in SAP HANA. Also we can define a simple restriction to a set of complex restrictions with the help of Analytic …

Read More »

SAP HANA – Classical Analytic Privileges

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 done with the help of Analytic Privileges. What is an Analytic Privilege? Analytic Privilege is used to restrict accessing of entire data present in information models (modeling objects) in SAP HANA. Also we can define a simple restriction to a set of complex restrictions with the help of Analytic Privileges …

Read More »

SAP HANA – SQL Analytic Privileges

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 going discuss about the process of data security in SAP HANA. The data security on HANA modeling objects can be done with the help of Analytic Privileges. What is an Analytic Privilege? Analytic Privilege is used to restrict accessing of entire data present in information models (modeling objects) in SAP HANA. Also we can define a simple restriction to a set of complex restrictions with the help of Analytic …

Read More »

SAP HANA – Privileges required by a business user

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 data) but not all. In this article, we will see the minimum privileges we need to assign for a business user in SAP HANA. Note: Users for business should be present in HANA when they are using SAP Lumira desktop application and advanced analysis office in organization. We have 6 …

Read More »

SAP HANA – Introduction to Data Provisioning

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 data provisioning options available into two categories, they are SAP HANA in-built tools External Tools 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 …

Read More »

SAP HANA – Rank Function in Calculation View

Hello Everyone, In this article, we are going to discuss about how to build rank function using graphical Calculation View in SAP HANA. Before we go ahead and see how to build this, let’s look at details about RANK function. RANK: This function calculates the rank for a data set based on the partition and ordering clause. This will be very useful when we have to pick latest records from multiple records or top N or Bottom N records from the source set. SQL Syntax: RANK() OVER (PARTITION BY <Colum Name> ORDER BY <Colum Name> ASC/DESC) SAP HANA Supports RANK …

Read More »

Loading Data to SAP HANA – Using SLT

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 target system: SLT (SAP landscape Transformation) DXC (Direct Extractor Connection) Through Flat file Through Data services Using HANA inbuilt EIM (Enterprise Information management) tools In this article, we are going to look at one the procedure of loading real time data from SAP/Non-SAP source system to HANA called SLT (SAP …

Read More »

Loading Data to SAP HANA – From Flat file

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 see the steps involved in loading data from flat files (.csv or excel) to SAP HANA database using SAP HANA Studio. Below are the basic five steps involved during this activity. Create the table Make sure we have a file with data in our local system Select the file Manage …

Read More »

SAP HANA – SQL Data Types

Hello Everyone, Before we work on any database, it is very important to know the different types data that database can store and limitations with each one of the data type. The way database stores the data is defined by us with the help of data types available while creating tables. In this article, we are going to look at the different data types available in SAP HANA while creating tables and their limitations. In SAP HANA, the data types are basically classified into 7 categories depending on the type of data they can store. They are, Date Time Numeric Boolean Character/String Binary …

Read More »

SAP HANA – Data Type Conversion Functions

Hi Everyone, In any Data warehousing system, one of the main objective is to transform the source data into meaningful information which can be easily understood and analyzed by business. In order to achieve this we need to have knowledge on the different types of functions available at database level and how to use each of those functions. The SQL Functions in SAP HANA are categorized into 9 types, they are: String Functions Numeric Functions Data Type Conversion functions Date Time Functions Window Functions Miscellaneous Functions Full Text Functions Aggregate Functions Series Data Functions

Read More »