Skip to Content
avatar image
Former Member

Where SAP BW saves it's workbooks?

Hi everyone,

I'd like to know where workbooks are saved in SAP BW system (phisically). Is there any backup? My college deleted a query and whole workbook disapeared. Is this normal?

Regards,

JN

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jul 17, 2009 at 07:59 AM

    Hi

    Workbooks always been stored inside a Role.

    If you user don't have access to any Role then also any query result from Bex Analyzer

    can be stored inside Favourites.

    Followings are the SAP tables which will let you know about Worbook storage in SAP BW:

    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 u2018Where-used listu2019 for reports in workbooks

    Regards,

    Vivek Tripathi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 17, 2009 at 06:10 AM

    Check the table RSRWORKBOOK

    Get the ID of the workbook from RSRREPDIR table

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 17, 2009 at 06:15 AM

    Hi,

    Workbooks will be saved under favorites folder.

    See if a query got deleted the depandant workbooks also will be delete.

    for backup am not sure have to search in sdn.

    Reg

    Pra

    Add comment
    10|10000 characters needed characters exceeded