Skip to Content
avatar image
Former Member

BW Workbook roles

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jun 25, 2010 at 11:50 PM

    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.

    in-which-bi-table-workbooks-are-physically-stored

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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