Where used Bex Query

[former_member195631]

Hi guys

I've copied a list of queries from an Infocube to a multicube

Now, I want to change all existence of the old queries with the new ones.

the queries exists in several areas:
1. Workbooks
2. Broadcasts
3. APD processes
4. SAP Portal roles
5. BO Webi reports

I've managed to find related tables for areas 1 and 2
Any suggestions for how to get "Where used list" for areas 2,4 and 5 ?

Any info will be appreciated

Thanks

Shlomi

[former_member183012]

Hi Shlomi,

For APD

you can find list of queries from table - RSANT_PROCESSI

in the table you restrict object types as ELEm it will give you no of APD which as query copy all object names form this table and provide to RSZCOMPDIR its will give you query name

Regards,

Ganesh Bothe