Here is the scenario, I need to create a new Query (ABC_2006)on the multiprovider (ABC).The query (ABC_2006) should be an exact copy of the query (XYZ_2006)on the multiprovider (XYZ).
Here , the multiproviders XYZ and ABC are not similar.
So, Please let me know the steps to follow to create the query.
Thanks in Advance,
If the source and target do not have the same objects its not possible to copy a query from one to another. But you can give a try if the objects used in the query are present in both the multiproviders even if both have diff objects(but both should have the same objects used in the query).
Otherwise you need to make changes to respective function module of SAP if u have access key which is not at all recommended.
Hope this helps you....
If the two Infoproviders are similar in structure then we can copy the query as it is.
The target InfoCube, that is, the InfoCube of the query copies, must contain all the InfoObjects of the source InfoCube (InfoCube of the original queries).
Go through the link it may be of some use:
*Assign points if it helps...