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

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

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

Referential Join In SAP HANA

By | August 11th, 2015|HANA|

Hello Everyone, In this article, we are going to discuss about the referential join which is available while building Attribute View and Analytic Views in SAP HANA. What is Referential Join? A referential join is similar to an inner join that assumes that referential integrity is maintained between the two [...]

SAP HANA – SQL 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 going discuss about the process of data security in SAP HANA. The data security on HANA modeling objects can [...]

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

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

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

Single character language codes for text join in sap hana

By | August 14th, 2015|HANA|

Hello Everyone, In this article we are going to discuss about how the text/description data is stored in SAP HANA when we are planning to implement text join. If we are looking for dynamic description based on the user login session language when user executes report, then the language column [...]

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