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