How to find out Query last used by whom

[Former Member]

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

[Former Member]

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.

[brian_keenan]

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