Skip to Content
Author's profile photo HP pampana

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

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Raman Korrapati
      Raman Korrapati

      Very useful article and nice presentation. keep it .up. Thanks for sharing

      Author's profile photo Former Member
      Former Member

      This is only for BI, not for ECC6.0

      Author's profile photo HP pampana
      HP pampana
      Blog Post Author

      This is for only Bex Queries. Thats why i created this blog in "SAP Netweaver Buisiness Warehouse" Space.

      Author's profile photo Manna Das
      Manna Das

      good explanations

      Author's profile photo HP pampana
      HP pampana
      Blog Post Author

      Thank you Manna Das......