cancel
Showing results for 
Search instead for 
Did you mean: 

Copy of Query

Former Member
0 Kudos

Hi Experts,

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,

BI Consultant

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

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....

Former Member
0 Kudos

Hi,

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:

http://help.sap.com/saphelp_bw30b/helpdata/en/f1/0a5a2ee09411d2acb90000e829fbfe/frameset.htm

Best Regards,

DMK

*Assign points if it helps...

Former Member
0 Kudos

Use TCode RSZC ?