Skip to Content

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

Table.JPG

Provide the query Name and excute

Query.JPG

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

sas.JPG

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

To report this post you need to login first.

5 Comments

You must be Logged on to comment or reply to a post.

    1. HP pampana Post author

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

      (0) 

Leave a Reply