How to get a list of workbooks used by a user in SAP BW?

[former_member246288]

Hi Experts,

We have a requirement like, we need to find the list of workbooks/queries used by the user assigned in his role in the system.Is there any table for this?

Thanks,

Ashu

[former_member182997 · Accepted solution]

See if this helps..

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

[former_member246288 · Accepted solution]

Thank for your reply, These T codes dosent have the data I need..:)

[former_member182997 · Accepted solution]

ok, please check this :

[former_member246288 · Accepted solution]

AGR_HIER...table give the details of workbooks in a role..but I need the list of workbooks used by the user..I mean some kind of  log which shows how frequently he is using the workbooks and which workbooks is he using daily/weekly/monthly.. assigned under his role....Thanks

[Loed · Accepted solution]

Hi,

I'm not sure but I think you can have this in one of the BI STAT providers..Did you activate them?

Regards,

Loed

[former_member186696]

Dear Ashu,

I create a document showing all tables of BW system.

You can consult which tables you can to review which objects you want to know.

The document is constantly updated:

http://scn.sap.com/docs/DOC-60453

Also, the same information is available at RSA1 - Metadata Repository.

Best Regards,

Edward

[sapna_jgurudutt]

Hi Ashu,

Can you please refer the following tables related to Queries and check whether it helps you:

RSZELTDIR - Directory of the reporting component elements

RSZELTTXT - Texts of reporting component elements

RSZELTXREF -  Directory of query element references

RSRREPDIR -  Directory of all reports (Query GENUNIID)

RSZCOMPDIR -  Directory of reporting components

Thanks & Regards,

Sapna

[Former Member]

0TCT_MCA1 gives statistics on Query, Workbook, WebItem etc User wise.

AGR_HIER...table give the details of workbooks in a role.

[Former Member]

But you need to check

Global Settings --> Statistics --> Collect Statistics Checked. If it is Unchecked you will not get Front end statistics.