Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Mar 25, 2006 at 03:37 AM

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

    dave schuh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.