on 01-23-2015 9:21 AM
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
Hi ,
Regarding the transformation expert script please refer to SAP documentation here:
Transformations in SAP HANA Database - Modeling - SAP Library
Kind Regards,
Des
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.