How to create HANA-based expert routines in BW 7.4 SP9 on HANA

[Former Member]

Hi,

Just a short update about which steps are necessary in order to implement a HANA Expert routine/script.

Note:

Important: Check out notes 2159872 and all prerequisite notes shown in the correction instructions. Also search for HANA Transformation in component BW-WHM-DST*.

It is now (SP9, in SP8 it works still the old way, just checked it) based on Abap Managed Database Procedures and you can use the editor of the ADT to write them which is a big help for the developer. The editor offers syntax checks and some functionality which couldn't be used in the earlier SPs.

Create a transformation for a data target which supports HANA transformations.

The targets that support HANA based transformations are as per today:

• (Classic) DSO

• (Classic) SPOs of type DSO

• ADSO

• Openhub Destination

Check if an initial proposal of direct field assignments can be pushed down to HANA by hitting the button:

You should see this message:

The target structure of the example looks like this:

If the transformation can be pushed down, create a HANA expert script:

Determine the ABAP class which will contain the DB procedure as an ABAP Managed Database Procedure:

Copy the name of the class, here TR_0002...JNCXD into the clipboard. You can write it down on paper as well but I personally prefer the first method.

Once the TRFN is active, you can find the class name also under

Search for the class in the ADT within HANA Studio (the ADT must have been installed previously (if you are using the BW Modelling tools, it is).

Switch to the ADT perspective:

and search for the class:

Find the method 'PROCEDURE':

and adjust it to your needs:

Activate the method and return to the transformation.

It should look like this:

Create a DTP  and execute it:

Check the result:

Enjoy!

Cheers, Philipp