BW Workbook roles

[Former Member]

Hello friends,

In SAP BW, there are some roles called as workbook roles where a query can be stored as workbook. Usually, nothing is maintained in the authorization tab except under s_tcode (field value RRMX). The workbooks are stored through Bex.

Now, my question is, do we have a table in SAP such as AGR_TCODES for listing the reports present in a workbook role?

Thanks,

Venkat

[Former Member]

Venkat,

In main role you find these authorization for workbook to get saved in a role.

S_USER_AGR : Workbook Name

ACTV : 01,02,22

S_USER_TCD : RRMX

S_GUI,ACT=60 ACTV : 60

S_BDS_DS 03,30

class type OT

RSWB_REORG_ROLES to identify what workbooks are not attached to a role.

RSRWBINDEX List of binary large objects (Excel workbooks)

RSRWBINDEXT Titles of binary objects (Excel workbooks)

RSRWBSTORE Storage for binary large objects (Excel workbooks)

RSRWBTEMPLATE Assignment of Excel workbooks as personal templates

RSRWORKBOOK 'Where-used list' for reports in workbooks

check the tables starting with RSRWB*

Thanks,

Sri

[Former Member]

THanks Sri. I will look into the RSRWB* tables.

[Former Member]

Hi Sri,

Is there any direct way to find/identify what workbooks are attached to a role?

Can we get this by joining tables using query viewer? Please let me know.

Regards,

Venkat

[Former Member]

Venkat,

Check the transaction RRMXP transaction. Here you can find all your active worbooks and queries in the system. If you dont find it, then it is not available in system at all.

or

First get the list of workbooks from the table RSRWBINDEXT

Table AGR_HIER.

select the role, and see the uid of the workbook and the title of the workbook.

To see all the roles with workbooks select RRMX in REPORT field.this will show you all roles with their workbooks.

Thanks,

Sri