Skip to Content
0

Where used Bex Query

Dec 27, 2017 at 01:34 PM

32

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

avatar image
Former Member Jan 04 at 10:51 PM
0

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


apd-table.jpg (45.5 kB)
Share
10 |10000 characters needed characters left characters exceeded