HANA

SAP HANA – Introduction to Administration

Hello Everyone, In this article let’s learn about Administrative Console and try to understand what are the tasks performed by each tab in the console. What is Administration Console? The Administration Console perspective helps us in the administration aspects of SAP HANA. This perspective is helpful for SAP HANA technology users (database administrators) who work on the regular administrative tasks, which involves maintaining, monitoring system status & disk volume usage, configuring alerts and so on. Let us go through and learn about different tabs in this perspective.

Read More »

Single character language codes for text join in sap 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 should store single character codes for language as shown below. In the above table, ‘E’ in the language column represent description is in English language and ‘D’ for Germany.   Interested in learning how to implement text join in SAP HANA, please read article ‘Implementing text join in HANA’ How …

Read More »

SQL Aggregate Functions in SAP HANA

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 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 to use 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 In this article, I would like to explain about the …

Read More »

Difference between Variable and Input Parameter in SAP 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. In this article, let’s looks at the differences between Variables and Input parameters. 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 …

Read More »

SAP HANA – Distinct count using counter

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, just count of products would give us wrong result because customer might have brought same product multiple times. We should be able to calculate distinct count of products to get right solution. This can be achieved with the help of ‘Counter’ feature available at both Analytic and Calculation View in …

Read More »

SAP HANA – Input Parameters

Hello Everyone, Sometimes we get tricky scenarios where we need to perform additional calculations or populate new columns after applying transformations to the user input value. These kind of requirements can be achieved with the help of input parameters in SAP HANA. What is Input Parameter? Input parameters in HANA are used to filter the data using the user input value as source to perform additional calculations which helps solving dynamic data population scenarios.

Read More »

SAP HANA – Restricted Column/Measures

Hello Everyone, In this article, we would like to explain about one of the feature available in Analytic View/Calculation View which is Restricted Column/Measure. What is Restricted Column? Restricted Column is an additional measure created based on Attribute restrictions. Example: Business wants to have additional column for Sales Amount based on calendar year. Let’s say one column for Current Year and another column for previous year sales.

Read More »

SAP HANA – Variables

Hello Everyone, One of the frequent requirement that most of the business users will always ask is ‘Can we filter our data during the runtime?’ We use to design such kind of requirements at reporting level because of the limitations with RDBMS (relational database). Now with SAP HANA in place we can fulfill these scenarios at HANA level itself which improves performance as well as reduces the data transfer between Database and reporting layer. In this article, we are going to explain how to implement run time filters in SAP HANA by using Variables. What is a variable? Variables are …

Read More »

Temporal Join for time dependent data in SAP 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 on the temporal column values from the transaction data and the time validity from the master data. Note: Temporal join is only possible to define on Analytic View. If you would like to know about all the join types available in SAP HANA, please go through ‘Join types in SAP …

Read More »

Referential Join In SAP 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 tables, which means that the left table always have a corresponding entry on the right table. This can be seen as an optimized or faster inner join where the right table is not checked if no field from the right table is requested. Meaning that the Referential Joins will be …

Read More »