How do I...Mimic Replacement Path with Query using Customer Variable Exits?

[david_schuh]

Hello SDN:

We are on BW 3.5 SP16.

We are currently using a replacement path Query(RP) with variables

to populate a variable in another Query(T).

The problem we are having is with performance.

The entry of variables in replacement path Query(RP) is optional (This is necessary there cannot be required values)

When results from Replacement Path Query are small performance is fine. (e.g. 10 seconds)

When results from Replacement path query are large performance suffers. (e.g. 1+ minutes)

Users are free to leave the replacement path variables empty resulting in a large set of data to be replaced. This is the worst performance case.

We would like to discover a way to conditionally execute the replacement path query. That is if users do not enter values for the replacement Query(RP) variables do not execute the replacement path query(RP).

Does anyone know if this is possible within reason and in customer exit space?

We have reviewed the situation from all angles and the requirement for the replacement path FUNCTIONALITY and the freedom for the user to leave variable values blank remains.

I've been searching and reading SDN and SAP notes for about a week and do not find threads which address this situation.

We are also exploring Customer variable exits to mimic replacement path functionality

(different topic subject="How do I...Mimic Replacement Path with Query using Customer Variable Exits?")

Any help will be appreciated

Many thanks

David Schuh

[david_schuh]

My appologies-I posted this message with the wrong subject. I will repost it with appropriate subject.

dave schuh