Query Last time used.

[Former Member]

Hi Experts,

Apart form using technical content, is there any table that gives us details about when a BEx Query was ran last time and by whom?

Regards.

[Former Member]

hi

You need to setup the statistics, use transaction RSDDSTAT.

The statistics will then be stored in the table RSDDSTAT_OLAP for reports

(or)

Check table RSZCOMPDIR

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.

Regards

Chandu

[Former Member]

Hi Kumar,

As I know there is no other table in BI apart from technical content which will store the run time information of a query. You can get other details e.g. when the query got changed and etc. but not run time information.

Regards,

Durgesh.

[naresh_babu3]

Kumar,

You can find your requested detals in the table - RSDDSTAT_OLAP .

UNAME - username who executed the query last tme .

OBJNAME - give you the query name .

just give your query name for the OBJNAME field , you will get the uname who executed it ( if it was executed) and the timestamp when it was executed .

Hope this solves your issue .

Thanks,

Naresh

[Former Member]

HI kumar,

You can check the entries in RSZCOMPDIR

PLease let us know for furhter information

Regards,

MADhu

[Former Member]

Thanks Madhu.

I'm also interested to know who ran the query last time?

Cheers.

[former_member182470]

Hi Kumar,

Just type RSZ* in Se11 and see........

Regards,

Suman