Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Copy and Paste Query

Does anyone know how to copy a query from one infocube to another? I tried trans code RSZC but it did not work as I anticipated.

As always, thank you in advance for your help!

Former Member

Hi Shelly,

RSZC will only work if the cube that you are copying the query to (target) has all the InfoObjects (chars and KF and Nav Attr) of the cube from which you are copying the query (source). This is required even if all of these are not being used in the query. When you try using RSZC, the system will point out what is different...if it is something just like nav attr then you can easily maintain that in the target cube for the sake of copying the query, but with missing chars or KF this may not be possible to that case you will just have to recreate the query.

Another option is to create a multiprovider based on both these cubes, copy the query from Sourec cube to Multiprovider, remove the source cube from the multiptovider, and then copy the query from multprovider to the target cube.

Hope this helps...

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question