Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Review and clean up old queries/workbooks

Hi Experts,

I have doubt in tracing out the Unused workbooks in BW 3.5.

Is there a easy/automated way that we can run statistics of workbooks every 3 months and identify workbooks that are not being used.

I tried using the standard statistics workbooks and one of the RS* tables- but did not get much luck.

Now i have to get the information on unused workbooks. Is there any automated process to trace out the unused workbooks list.

Thanks in Advance

Regards

Prasad

Former Member
Former Member replied

Hi,

Try:

RRMX_WORKBOOKS_GARBAGE_COLLECT -- identifies and removes orphaned workbooks.

RSWB_ROLES_REORG -- deletes favorites attached to deleted workbooks.

OSS Note 385219 -- identifies many workbook cleanup programs.

Table RSRREPDIR -- Directory of all reports (workbooks or queries?)

As always, test these out in DEV first so you know what these programs will do!

Brian

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question