Lookups in BWonHANA
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!