Skip to Content
0
Jul 13, 2007 at 12:47 PM

BW statistics - query last start

13 Views

Hello everybody,

I need your help please!

I'd like to have a list of all queries we have, with their last run date, so I can see which queries were not use in the last 3 month for instance, but not using the Technical Content. (BW3.5) For this purpose I can list all entries in the table RSDDSTAT, which contains all I need.

The problem: the query ID in the table is like "5SURAN3E4IOJ53YXIHR2EEQGM" so I need the correlation between this ID and the technical name of the query.

For example: Z_JMT_KAW_AB_AUSL -> 5SURAN3E4IOJ53YXIHR2EEQGM.

Do you have any idea?

Thanks in advance!