Hi BEx community,

These days I came across a requirement to find out when was the last used date of a certain Workbook. I could not find an easy way to enter the Workbook title and simply get the Workbook last used date information.

Anyway, I just found a three steps way to find out this useful information (let’s say you want to clean-up some unused Workbooks and want to make sure it was not used for the last couple of years, for instance). Below I describe how I found the Workbook last used date.

1- Make sure the system is collecting statistics for the given Workbook:

Enter transaction RSDDSTAT on BW backend, go to tab ‘Workbook’ and make sure the statistics are turned ON for this specific Workbook, otherwise you might no rely on this guide, since the Workbook might have being used but no statistics are being generated.

You can find more information about Configuring Statisics Properties on this link.

27-07-2015 15-51-52.jpg

2- Get the workbook_id information:

The Workbook statistics are saved under the workbook_id information and not it’s title, so we need to get this information before filtering the statistic table. Enter table RSRWBINDEXT on se16 transaction, filter attribute TITLE by the Workbook name and copy the value on WORKBOOKID attribute.

27-07-2015 15-52-19.jpg

3- Filter statistic table RSDDSTAT_OLAP to get last used date and other information:

With the workbook_id, enter table RSDDSTAT_OLAP on se16 transaction and filter attribute OBJNAME = workbook_id.

Make sure the values returned are NOT being truncate by the Maximum No. of Hits (You might need to use the CALDAY attribute to restrict the result-set if this is the case).

Once you have the results, you can sort it by CALDAY attribute in descending way. This same CALDAY will show you the last day the Workbook was used.

You can find other information such as UNAME: user that executed it; UTIME: time it was executed; etc.

27-07-2015 15-53-08.jpg

Hope this little Blog Post can help you to easily find out the Workbooks last used date for whatever reason you might need it. 😉

Cheers,

Eduardo

See other posts:

Terminations on BEx Queries due to missing/inconsistent logical indexes on SAP HANA

Unexpected values in Bex Query? Check out SAP collective notes for incorrect/wrong data in BW queries

Bex Query going into debug mode in RSRT? Check here how to find the solution

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

Leave a Reply