Remediation for HANA Migration

Before migrating to HANA platform, the custom developments in SAP need to be remediated for HANA compatibility as explained in SAP Note 1912445.

Steps to be followed:

1. Identify the code where modifications are required.

 Execute SCI for custom developments with check variants as ‘FUNCTIONAL_DB’ and ‘FUNCTIONAL_DB_ADDITION’.

SAP HANA ABAP: SQLScript: Functions Part-1

The Goal of AMDP implementation is always to remove any additional logic required at the abap layer i.e. avoid loops, further joins, formatting or data conversions. To achieve this, we can leverage HANA SQL functions to ensure the that the data being returned from AMDP is complete and needs zero or a light touch while passing to the ABAP Layer.

Using the below explained functions we as a HANA developer can make our lives easier.

New SAP Help Portal Goes Live: What it Means for SAP HANA Dynamic Tiering Users

Getting to the Content

To find the dynamic tiering documentation, just search for “dynamic tiering” or “SAP HANA dynamic tiering” from the homepage.

Text join using pa0000 table in hana

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 description in that language.

Port Forwarding SAP HXE instance (VM) to allow connection from SAP BO 4.2 on the Cloud

In this post I will show you how I succeeded connecting SAP BO Platform 4.2 on the Cloud with my local SAP HXE instance (VM) for educational purposes only.

Scenario:

In my case, I do not have any of the SAP BI Client Tools, such as SAP BO IDT, SAP BO Webi Rich client, SAP Design Studio, and so forth installed on my devices. Reason is because I do not have authorization to download any software from SAP Download Center (which makes sense). So, my only gateway is the SAP BI Launchpad.

New Hana backup software

Hello, I would like to present a new backup software that we N’Ware Technologies have been developing to support our customer running on Hana.

We made this backup software because existing backup software were missing basic functionality or were complex to use.

linux Bash scripts/windows dos scripts to automate backups are complex to the normal user to manage. It requires specialized knowledge on how to use the command line, sometimes on linux that user might not know, and offer no other functionality than the basic 1 backup per day.

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

This blog will explain below –

1. Creation of Repository Stored Procedure
2. Calling Stored Procedure through Abap class
3. 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 data from HANA view and insert the data into HANA table.

How Classify The Classes based on Percentage in SAP HANA

Degree classification has a long history in our universities. It is widely accepted by students, parents and employers as the measure of academic achievement.

In this blog I am classifying the Student classes based on there percentage. If Student get above 60 percentage then they will get “FIRST CLASS” or If Student get between 60 to 50 percentage then they will get “SECOND CLASS” or If Student get below 50 percentage they will get “THIRD CLASS”.

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

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 are calculated at run time based on the existing column and using either functions, input parameters and constants.

Providing OpenSSL certificates for domains defined in HANA XSA

To start with, I create a server certificate for my HANA XSA system as usual: