How to know the list of users who runs the particular Query and at time of the execution

We can check theList of users who used particular query in RSSDDSTAT Table.

If you install BW statastics standard providers we can check the data in  0BWTC_C10 Multiporvider .if not we can check the data in RSSDDSTAT Table.

Below are the steps :

Go to Se16

Provide theTable name as RSDDSTAT

Provide the query Name and excute

It will display the users list who used the Particular query and displays the time stamp also.

Below are the steps to  activate the BW Statistics:

·         To activate statistics goto tcode RSA1à Tools à Settings for BI Stats

·         Set stats for Query- set stats for InfoProvider    

·         Set stats for Web Template- set stats for Workbook

Below are the some tables to check the statastics

RSDDSTATAGGR              Detail Table for Aggregate Setup

RSDDSTATAGGRDEF      Detail Table of Navigation for each InfoCube/Query

RSDDSTATSTEPTP:           Type of steps

BEX, BEX3, BRCS (broadcasting), EXTN (external read), JAVA, MDX

RSDDSTATHANDLTP:     combines Handle & Step type

Helps to identify where the time is being spent

RSDDSTATWHM:            Time it takes to do a load

RSDDSTATCOND              InfoCube Compression

RSDDSTATDELE                InfoCube Deletions

RSDDSTAT_WRITE           InfoCube Writes

RSDDSTATBCACT              Business Content Activation Statistics

RSDDSTATCOND               Data on Condensing Run InfoCube

RSDDSTATEXTRACT         Time of last delta load