2 Replies Latest reply: Jan 19, 2011 7:26 AM by Omprakash Mishra RSS

How to find out Query last used by whom

sankar reddy
Currently Being Moderated

Dear All,

 

Can any one tell me that "How to find out the Query last used by whom. I have already searched in SDN but no luck. In my system BW Stats are not installed and I have already checked the below tables.

 

RSZELTDIR  - Directory of the reporting component elements

RSZELTTXT  - Texts of reporting component elements 

RSZELTXREF  - Directory of query element references 

RSRREPDIR -  Directory of all reports (Query GENUNIID) 

RSZCOMPDIR -  Directory of reporting components 

RSZRANGE  - Selection specification for an element 

RSZSELECT -  Selection properties of an element

RSZELTDIR - Directory of the reporting component elements 

RSZCOMPIC -  Assignment reuseable component <-> InfoCube

RSZELTPRIO -  Priorities with element collisions

RSZELTPROP - Element properties (settings)

RSZELTATTR - Attribute selection per dimension element 

RSZCALC - Definition of a formula element 

RSZCEL - Query Designer: Directory of Cells

RSZGLOBV -  Global Variables in Reporting

RSZCHANGES  Change history of reporting components 

 

I am able to find out the Date and time but not the user name.  So could you please help on this.

 

Regards

Sankar

  • Re: How to find out Query last used by whom
    Brian Keenan
    Currently Being Moderated

    Hi,

    You need to setup the statistics,  use transaction RSDDSTAT.

     

    The statistics will then be stored in the table RSDDSTAT_OLAP for reports.  And you can search for it in here.  However it is more flexible to see the data via the BI admin cockpit.

     

    964418  Adjusting ST03N to new BI-OLAP statistics in Release 7.0

    934848  Collective note: (FAQ) BI Administration Cockpit

  • Re: How to find out Query last used by whom
    Omprakash Mishra
    Currently Being Moderated

    i think u have missed it.

     

    RSZCOMPDIR IS THE ONLY TABLE WHICH PROVIDES THE DATA.

     

    ENTER TECHNICAL QUERY Name in RSZCOMPDIR-COMPID.

     

    RSZCOMPDIR-TSTNAM gives you the user id of sap bw user who made the change.

     

    RSZCOMPDIR-TSTPDAT gives you date on which  change was made .

     

    RSZCOMPDIR-TSTPTIM   gives you timestamp on which  change was made .

     

    all users details can be obtained from TCODE SU01 where you need to enter sap user id.

     

    You can also get user name( description) by using tcode SE09 and entering above sap user id.

Actions