Page 1 of 1
Report Execution History
Posted: Tue Aug 16, 2011 5:55 am
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.
Re: Report Execution History
Posted: Tue Aug 23, 2011 12:50 am
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.