cancel
Showing results for 
Search instead for 
Did you mean: 

Lookups in BWonHANA

Former Member
0 Kudos

Hi all,

we are actually trying to figure out how to execute lookups in a BWonHANA.

In traditional BW systems, we are using lookup-classes either with singleton-pattern or with FOR-ALL-ENTRIES functionality to add additional data to a datarecord.

However, as we are willing to keep all transformations HANA optimized, there is no more way to execute ABAP logic within a transformation.

So we do see the following possibilities:

1.) using standard functionalites "read from master data" and "read from DSO" => no error handling is possible. Also lookup is only possible with complete key access

2.) using CompositeProvider in JOIN mode => if we need to store the looked up data historically, it has to be available with time-dependency

3.) using SAP HANA expert script?? => how to execute lookups in BW transformations with SAP HANA expert script??? (does somebody have some sample-coding for this?)

As lookup is, in our point of view, a key-functionality with SAP BW data integration and harmonization, we really would appreciate a "best-practice" way to do this in SAP HANA.

That's why we'd be happy if you could share some input about this!

Regards

bivision

Accepted Solutions (0)

Answers (2)

Answers (2)

desgallagher
Contributor
0 Kudos

Hi ,

Regarding the transformation expert script please refer to SAP documentation here:

Transformations in SAP HANA Database - Modeling - SAP Library

Kind Regards,

Des

Former Member
0 Kudos

hi, unfortunately, in this doc nothing is mentioned about AMDP .We do have the problem that all our developers are not skilled in SQLScript, but in ABAP. So is there any "light transition" for them to grasp the most important tasks in SQLscript asap instead of going through 200 pages of reference guide?

shanthi_bhaskar
Active Contributor
0 Kudos

you should using the For all entries with the help of HANA Hint..That improves the performance a lot.

Hint FM : RSDU_CREATE_HINT_FAE

You can refer the below code for reference.

Former Member
0 Kudos

hi,

unfortunately, this is no option. As soon as you include any ABAP coding except AMDP, the whole processing will be pushed to the application server.

So we really need a complete solution which is processed on HANA DB only...I'm afraid this will only be the AMDP...

regards

bi vision