Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Lookups in BWonHANA

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!



Former Member
Not what you were looking for? View more on this topic or Ask a question