SAP Netweaver Business Intelligence BI / BW

Symptom

Reorganizing workbooks can be necessary for the following reasons:
Variables cannot be deleted because they are being used in queriesQueries cannot be deleted because they are being used in workbooks…Workbooks are available in roles or favorites, but cannot be found in the document storage

However, the corresponding workbooks do not exist in any role and they do not exist or are not visible in the favorites of all users.
Workbooks, to which no reference exists anymore in a role or in the favorites, can exist. Similarly, references to workbooks can exist in roles or favorites, however, these workbooks do not exist (anymore) in the document storage.
Other terms

BW 2.0B, BW 2.1C, BW3.0A, BW3.0B, BW3.1C, Business Explorer, Business Explorer Analyzer, BEx Analyzer
Reason and Prerequisites

The cause for such a reorganization of workbooks could be:
incorrect transports, that is, a transport of workbooks without the corresponding roles orthe deletion of workbooks in the SAP Easy Access menu or in role maintenance (Transaction PFCG).

In the SAP Easy Access menu or in role maintenance, the references to workbooks are deleted, without a check being carried out to see whether it is possibly the last reference. In this case, the workbook is also deleted in the document storage in the BEx Analyzer or BEx Browser.
The SAP Easy Access menu and role maintenance belong to component SAP Basis and thus they do not allow a BW-specific jump during deletions.
Solution

ReportRS_WB_ROLES_REORGis delivered with BW 2.0B Support Package 14 (see Note 374840). In BW 3.0A, ReportRSWB_ROLES_REORG(please note the different name) is delivered with Support Package 3.This report allows you to delete the references to workbooks in roles and favorites, whose workbooks do not exist in the document storage. The report also allows you to delete workbooks, for which no references exist in roles or favorites, in the document storage.
ReportRS_WB_ROLES_REORG (2.0B/2.1C)orRSWB_ROLES_REORGfirst displays the defective references and workbooks in a list, before the references or workbooks to be deleted are chosen and deleted.
Technical description
The following technical description explains how workbooks can be deleted manually.

1. Determine workbook ID (WBID)
If the workbook ID is already known, you can go to step 2.
You can search for the workbook title in table RSRWBINDEXT to obtain the workbook ID (WBID) using the table display (Transaction SE16).
2. Check for references
Function module RSBB_WORKBOOK_AGR_GET can be executed using Transaction SE37 (menu Function module/Test/Single test F8). The workbook ID must be specified as parameter I_WORKBOOKID. In the internal table E_T_AGR, no roles or favorites should be listed with a reference to these workbooks after executing the module.
3. Delete workbook
A workbook can be deleted using function module RRMX_WORKBOOKS_DELETE (execute using Transaction SE37 and Test). Parameter workbook ID (I_WORKBOOKID) and object version (I_OBJVERS) must be specified. Normally the object version is “A”, but it can also be taken from the above-mentioned table RSRWBINDEXT (column OBJVERS).
It should be possible to delete variables and queries without problems afterwards.