I've created some favorite workbooks and wondering where they are stored.

[Former Member]

Where and how are BW favorites stored?

[former_member188080]

Hi,

Check following tables

The following are the tables in SAP BW which store information related to workbooks in the back End. Go to SE16 and just enter the table name:

Table Name Use of table

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

Thanks and regards

[former_member182516]

Workbooks always been stored inside a Role.

If the user don't have access to the role then he cant access those workbooks.

Table Name Use of table

-

---

RSRWBINDEX List of binary large objects (Excel workbooks)

RSRWBINDEXT Titles of binary objects (Excel workbooks)

RSRWBSTORE Storage for binary large objects (Excel workbooks)

[Former Member]

Hi,

when ever you create workbooks it can save in Favorites(its local to the user) or you can save in to the roles whre others can access ...

check the below table

RSRWBINDEXT Titles of binary objects (Excel workbooks)

RSRWBSTORE Storage for binary large objects (Excel workbooks)

Regards,

Satya

[Former Member]

Hi LMM,

After saving the workbooks in Favorites they would rarely come back to BW Role. The users can manage Favorites folder themselves & they can make changes to the Report saved in Favorites as per their own need. The user can even add new folder in the Favorites & after saving the reports in the favorites it also appears in user Menu(SAP Easy Access).

Please also refer the following document for your reference.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e082b5fb-7ac9-2e10-f4b2-a9f0118a6...?

QuickLink=index&overridelayout=true

Assign points if helpful.

Regards,

Amit

[Former Member]

Hi LMM,

Some more link for your question,

http://help.sap.com/saphelp_nw04/helpdata/en/ba/45583ca544eb51e10000000a114084/content.htm

Regards,

Amit

[Former Member]

I guess I was wondering where in SAP they are stored. They are not local to the user. We have a user saying their favorites are gone and i'm wondering if I can see them and retreive them

[Former Member]

Hi,

The very first thing is, your favorites are local to every user and one user can not access favorites of other use. And they are stored in table RSRWBSTORE.

Check the below link for more information,

[http://wiki.sdn.sap.com/wiki/display/BI/Addworkbookstousermenu+Favorites]