HANA

SAP HANA – Overview of Modeler Perspective

Capture

Hello Everyone, In this article, we are going to discuss about the main perspectives available in SAP HANA studio and how to use them in our day to day work. Please go through the article ‘SAP HANA Studio Overview’ to know how to install SAP HANA and studio and basics steps needed to perform in it before we start our actual work.

Read More »

Privileges required for a Modeler in SAP HANA

Capture

Hello Everyone, Most often during HANA implementation, as a modeler we go to HANA admin asking for additional privileges wondering what are the minimum privileges required for modeler to work in HANA. In this article, we would like to show you what are the minimum privileges required for modeler in SAP HANA. We have 6 different types of privileges in HANA, they are System Privileges Object Privileges Analytic Privileges Package Privileges Application Privileges Privileges on users Hello Everyone, Most often during HANA implementation, as a modeler we go to HANA admin asking for additional privileges wondering what are the minimum …

Read More »

Level Hierarchy in SAP HANA

Capture

Hello Everyone, In this article, we are going to look at different types of hierarchies available in SAP HANA and how to create them. What is Hierarchy? Hierarchies helps business to analyze their data in a tree structure through different levels/layers with drilldown capability. Each hierarchy comprises of a set of levels having many-to-one relationships between each other and collectively these levels make up the hierarchical structure. For example, a time hierarchy comprises of levels such as Fiscal Year, Fiscal Quarter, Fiscal Month, and so on. We can create two types of hierarchies in SAP HANA, they are Level Hierarchy …

Read More »

SAP HANA – Generate Time Data

Capture

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 different time elements like year, quarter and month and so on. Using ‘Generate Time Data’ option in HANA Studio, we can generate the time data into the system specific table automatically and use them in the analytical models instead of loading it from source system. All the time data tables …

Read More »

SAP HANA – Calculation View ( Creation Using GUI)

Capture

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 the same.   What is Calculation View? A calculation view is a powerful and flexible information view, which can be used to define more advanced logic or complex calculations on the tables or information views available in the SAP HANA. Calculation Views provides the functionality that is available both in Attribute and Analytic View. Mostly calculation views are used when we were not able to design the business logic with the help of …

Read More »

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

Capture

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. This screen element was used to call as ‘Quick Launch’ till SAP HANA SP8 and renamed from SAP9 to ‘Quick View’. Note: This screen is only available when we are in ‘Modeler’ perspective of SAP HANA Studio.

Read More »

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

Capture

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. This screen element was used to call as ‘Quick Launch’ till SAP HANA SP8 and renamed from SAP9 to ‘Quick View’. Note: This screen is only available when we are in ‘Modeler’ perspective of SAP HANA Studio.

Read More »

SAP HANA – Architecture (Part 3)

Capture

Hello Everyone, In this article, we are going to discuss about the architecture of SAP HANA. The beauty of SAP HANA lies in its architecture. The way it is built makes it unique and very special compared to other databases. We had divided this article to three parts. In each article we try to explain the architecture of SAP HANA, different components involved, and their significance. In this article – Part3:  we will cover the below topics: Understanding the persistence Layer Understanding Backup and recovery Please follow the below links for rest of the parts. Introduction to SAP HANA Architecture …

Read More »

SAP HANA – Architecture (Part 2)

Capture

Hello Everyone, In this article, we are going to discuss about the architecture of SAP HANA. The beauty of SAP HANA lies in its architecture. The way it is built makes it unique and very special compared to other databases. We had divided this article to three parts. In each article we try to explain the architecture of SAP HANA, different components involved, and their significance. In this article – Part 2:  we will cover the below topics: Storing data – row storage Storing data – column storage Please follow the below links for rest of the parts. Introduction to …

Read More »

SAP HANA – Architecture (Part 1)

Capture

Hello Everyone, In this article, we are going to discuss about the architecture of SAP HANA. The beauty of SAP HANA lies in its architecture. The way it is built makes it unique and very special compared to other databases. We had divided this article to three parts. In each article we try to explain the architecture of SAP HANA, different components involved, and their significance. In this article – Part1:  we will cover the below topics: Understanding the SAP HANA architecture Explaining IMCE and its components Please follow the below links for rest of the parts. Introduction to SAP …

Read More »