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!
Bhanu Gupta replied
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 do...in 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...