The log on opening a query

[Former Member]

Hello, colleagues!

How can I see the log on opening a query by users in the system?

I need the information about opening a query (when, how many times, who did it).

Could you explain me, can I get this information? And how can I  get it?

With Best Regards,

Evgeny Sozonov.

[michael_devine]

Hello,

1. Run the Transaction code ST13

2. Select the tool name as :  BW_QUERY_USAGE and execute

3. Select the data range and execute based on the following selection

In SAP Netweaver BI 7.0 Query Runtime statistics is split into two major parts

1) Front End and OLAP Statistics : Provides -  Runtime of BI front end application and Runtime of Query in OLAP Processor

2) Data Manager :  Runtime for retrieval of data from BI Info Provider or the BI Accelerator

Refer following SAP Documentation links :

http://help.sap.com/saphelp_nw70/helpdata/en/43/15c54048035a39e10000000a422035/frameset.htm

http://help.sap.com/saphelp_nw70ehp2/Helpdata/EN/44/57f2c19b1a311de10000000a155369/content.htm

regards,

Michael