How to verify a Workbook last used date
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.
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.
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.
Hope this little Blog Post can help you to easily find out the Workbooks last used date for whatever reason you might need it. 😉
See other posts: