SAP HANA studio

Create a value help (for input parameter / variable) in HANA Calculation view

Input parameters and Variables are two diferent mecanism that HANA provide us to get interaction with final users. In some cases, we need to include an input parameters / Variables with value help with the propose of provide more information when user have to choose an input value. In this post I’m goint to explain the steps to create a custom value help and some tips that you have to …

Read More »

Create a value help (for input parameter / variable) in HANA Calculation view

Input parameters and Variables are two diferent mecanism that HANA provide us to get interaction with final users. In some cases, we need to include an input parameters / Variables with value help with the propose of provide more information when user have to choose an input value. In this post I’m goint to explain the steps to create a custom value help and some tips that you have to …

Read More »

Unassigned Member Null Handling Hierarchy in Calculation View

Not Assigned Members enabled hierarchies with SAP HANA Calculation Views   Often occurs that there will be entries in fact table for which corresponding master data doesn’t exist, for instance sales records for unregistered customers. In such cases when the two tables joined together with referential integrity, sales data for unregistered customers will be lost. Using the feature Unassigned Member Null Handling in hierarchy, we can see the whole data …

Read More »

HANA XS classic connection (e.g. Cockpit, HALM, Web IDE) is suddenly reported as “Not Secure”

Introduction: If your HANA Server communicates via https to serve the HANA Cockpit or HALM or any other XS website, with new browsers you may experience that your certificate is no longer trusted and your connection is reported as “Not Secure”. Affected Version: SAP HANA 1.0 SAP HANA 2.0   Debugging Steps: The latest browsers like Microsoft Edge, Chrome 58 etc. try to make the web experience as smooth as possible. …

Read More »

How To Find Average In Calculated Column Using Calculation View In SAP HANA

In this blog I am going to explaining about How To Find Average. Average : The sum of all of the numbers in a list divided by the number of items in that list. In my calculation view I am taking student four subject marks and finding the average to that marks using Calculated Column. Calculated Column : It is an additional column which can be created by us, the results of which …

Read More »

Text join using pa0000 table in hana

Hi all, I am sharing you concept called text join in HANA, which we mainly use to extract descriptive data from a table or language specific data from a table. Text Join is used in order to get language-specific data. Text Join is used to fetch the description based on user’s session language. Once we implement the text join in SAP HANA, it automatically find out user’s language and give …

Read More »

Calling HANA Stored Procedure from Abap class and scheduling it through Process chain (using AMDP – Abap managed database procedure)

This blog will explain below – Creation of Repository Stored Procedure Calling Stored Procedure through Abap class Calling Abap class in Abap program and scheduling through process chain The environment here is BW on HANA. The data modelling was done in SAP HANA view and there was a need to read the output of the view and persist it in the HANA table. Stored Procedure was written to read the …

Read More »

How To Calculate Student Average Marks in SAP HANA Studio Using Calculation View

Scenario : In This Scenario I am going Explaining about Calculating Student Average Marks using Calculated Column in Calculation View. Calculation Views are used to combine other Analytic, Attribute and other Calculation views and base column tables. These are used to perform complex calculations, which are not possible with other type of Views. Characteristic of SAP HANA Calculation View as below – Support Complex Calculation. Support OLTP and OLAP models. Support …

Read More »

Factory Calendar transpose in SAP HANA Studio step-by-step

Firstly I would like to reference a few blogs where some of the information to help with the below was sourced and would like to thank the bloggers for their invaluable contributions. https://blogs.sap.com/2016/06/27/factory-calendar-consumption-in-sap-hana/ (by Dmitry Kuznetsov Dmitry references blogs by Abani Pattanayak https://archive.sap.com/documents/docs/DOC-50541 & https://archive.sap.com/documents/docs/DOC-51791 _____________________________________________________________________________ INTRODUCTION & OBJECTIVE My experience was that I felt that some of the information provided was not detailed or comprehensive enough for me to complete the …

Read More »

Sap HANA passing value from one input parameter to other for filtering table (Parameter Mapping)

In this blog, I am going to explain how to pass value from one input parameter to other parameter and filter the underlying table without any process change in the view. CV_xxx_BASE View before changes Configuration of input parameter in current view was as under Parameter Type : Direct Semantic Type : Date Data Type : Date Table is getting filter from input parameter IP_ASOFDATE   Business Requirement    Changes …

Read More »