Moving Queries from one Infoprovider to another

[Former Member]

Hello Experts,

Does anyone developed a program to move queries from one infoprovider to another. RSZC tcode copies the queries from infoprovider to another. But my requirement is move the query completely from one infoprovider to another. Pl let me know if you have a solution for this.

Thanks & Regards ::

Balaji T

[chemicala_srimallikarjuna]

Hi,

1.You can use the function module "RSZ_I_COPY_QRY_TO_CUBE_SINGLE" to copy over the Query from one InfoProvider to another without any compliance check i.e., it will not check if all the InfoObjects used in the query are still available in the second InfoProvider.You can always adjust the query later on if the second InfoProvider does not have the same structure.

2.Also, there is the function module RSZ_I_COPY_QRY_TO_CUBE which copies queries from cube to cube or InfoProvider to InfoProvider.

Regards

CSM Reddy