Report Execution History

Business Warehouse

Moderators: Snowy, thx4allthefish

Post Reply
Posts: 5
Joined: Mon Apr 18, 2011 8:34 am

Report Execution History

Post by Wagner » 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.


Posts: 16
Joined: Wed Jul 20, 2011 3:56 am
Location: Australia

Re: Report Execution History

Post by JohnLang » Tue Aug 23, 2011 12:50 am

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 ... ontent.htm

For a better understanding about how the query statistics are created by the BW system ... see "BI Query Runtime Statistics" at ... ontent.htm

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

Kind Regards,

Post Reply