Usage of Analysis Process Designer (APD) - missing BEx-text

[Former Member]

Dear all,

Using the APD in order to populate a Transactional ODS based on a BW Query led to three questions. It would be great if 'best practices' and tips on this topic could be shared.

Thanks, Markus

1) if in the query (BEx) a InfoObject is set as display text and key only the key get's exposed to APD. In case I want to use both are there any know workarounds rather than looking up the text sequentially in APD routines?

2) any experiences in terms of performance using ADP?

3) how robust is APD for BW 3.1? As it uses internally the ODBO interface can it be assumed that it works as stable as e.g. RSCRM_BAPI?

[torsten_bachmann]

1) Currently texts can not be chosen within APD. Only keys can be retreived. In BW3.5 there is a workaround to use the DB-Table-source to retreive data from the Infoobjects Texttable and join it with the output of the query.

2) Please have a look at the general performance FAQ-note 794257. If the query definition is easy, please consider using the InfoProvider source instead of the query source.

3) Yes, in this Query->ODS scenario stability, limitations and performance are mostly related to RSCRM_BAPI. For limitations and performance issues of RSCRM_BAPI please have a look at notes 605208 and 605213.

Best Regards,

Torsten Bachmann