Page 1 of 1

Report Execution History

PostPosted: Tue Aug 16, 2011 5:55 am
by Wagner
Trying to figure out how to review what reports certain users have executed. Similar to ECC when looking in ST03N, STAT or SM20 for transaction history. Obviously with BI, users are not using transactions but executing iviews which in turn are accessing queries etc. Not sure how to answer audit questions regarding who has run what report etc.

Thanks

Re: Report Execution History

PostPosted: Tue Aug 23, 2011 12:50 am
by JohnLang
Hi Wagner,

Install/Activate the SAP Business Content for Statistics. You will be interested in DataSource 0TCT_DS01 which supplies data to the 0TCT_C01 cube. Once loaded you can use BW reporting itself to review the statistics of what the user community have been doing in the BW reports.

For an introduction to the "Aggregation of Query Runtime Statistics" see http://help.sap.com/saphelp_nw70/helpda ... ontent.htm

For a better understanding about how the query statistics are created by the BW system ... see "BI Query Runtime Statistics" at http://help.sap.com/saphelp_nw70/helpda ... ontent.htm

Don't forget to schedule a regular update of 0TCT_DS01 data into 0TCT_C01.

Kind Regards,
John.