BW query creation

[KALAISELVI]

Hi,

i have activated some standard business content standard dso and copied them into custom Advance DSO.I dont have authorisation to activate standard bex queries on top those models in DEV but need to create them as custom queries on top of new model.Your quick tips will be appreciated

[KALAISELVI]

Hi,

Apologize my question was not clear. 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

1)please confirm whether i can copy standard queries on top of multiprovider into my new Z-composite provider using any tcode in bw7.5?

2)If activation of standard queries on top of multiprovider is not allowed, Do we have any option for recreation of same queries on composite provider any option is there?

[VijayetaSharma]

Hello,

You need to create BEx transport request in Dev before system let you automatically capture BEx queries. Sometime Query Designer shows error/ warning if no BEx TR available. Apart from SU53 route, you can check below as well.
Go to RSA1 > Transport Connection > BEx Transport option on top> Assign / create a new Transport Request> Assign project> Save > Activate standard BEx.

Thanks,

Vijayeta