This website is not affiliated with, sponsored by, or approved by SAP AG.

Report Execution History

Business Warehouse

Moderators: Snowy, thx4allthefish

Report Execution History

Postby 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.

Thanks
Wagner
 
Posts: 5
Joined: Mon Apr 18, 2011 8:34 am

Re: Report Execution History

Postby 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 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.
JohnLang
 
Posts: 16
Joined: Wed Jul 20, 2011 3:56 am
Location: Australia


Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 5 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.