Copying bex queries

[Former Member]

Hi Experts, can anyone plz explain, how to copy bex queries from one sap system to another system

[Former Member]

Hi,

The 2 systems need to be connected using RFC. Since, you want to migrate the queries to a different landscape.  Make sure the version is same as in the BW source system as well as Target BW System.

Make sure all the Objects, DS's & Dataflows are similar and have been moved before moving the query. Create a request for the query & release it. After releasing this request a file will be created on the server. Take this file to other BW system & transport this request from STMS.

Hope it helps.

/Rohit.

[Former Member]

Have u tried RSZC for copying the query. Also, if there is a RFC Connection between the 2 Systems, you can transport the query. Explain in detail the scenario.

[Former Member]

It consists of queries , filters ,structures etc ..where we can copy from

source system to Target system