BW query copy from standard DSO to ADSO

[KALAISELVI]

Hi,

I have activated all business content model [Standard DSO & Cube] and copied them into Z-ADSO. In my project i need to recreate all queries on top of standard Multiprovider to new CP without activating the business content queries in development.[As activating data models are permitted,i just copied from DSO to ADSO]

1)If activation of standard queries on top of multiprovider is not allowed on development, Do we have any option for recreation of same queries on composite provider apart from manually creating?

2)If above option is not there,please confirm whether i can copy standard queries on top of multiprovider into my new Z-composite provider using any tcode in bw7.5?

3)how can we see exact standard bex query template of those standard business content queries inorder to manually create new one?

[MKreitlein · Accepted solution]

Hello Deepthi,

the easiest way would be you can get a copy of the Dev system as a Sandbox.

There you can activate everything and just build it in Dev via looking up in the Sandbox.

In BW, the t-code RSZC exists, to copy a query from one Provider to another, but I doubt it works from Multi to Composite. Have never tried this, but in general both, source and target provider need 100% the same structure. Otherwise it will not work anyway.

Hope this helps anyway,

Martin

[VijayetaSharma]

Hi kalai.sriram,

Welcome back again.

You should be able to create queries on top of CP/ standard infoproviders. SAP do not limits access in this regards. Access is restricted local in the system. So if you are getting auth error contact you SAP Security/ BASIS team.

TCode RSZC will not work as your are trying to copy queries from DSO to CP. It only works on same type of info-providers. Means DSO to DSO, Cube to Cube etc.

You can open existing quires via Query Designer. Query Designer should get installed along side SAP GUI (or at-least it offers an option to install Business Explorer). If you can not locate Query Designer request basis to install it for you. Once you have query designer you can perform side by side comparison/ creation of queries.

Best Of Luck!

Thanks,

Vijayeta