Skip to Content
0
Former Member
Oct 12, 2006 at 08:08 PM

List of Cubes/ODS not used by queries for long.

18 Views

Hi Experts,

I want to get a list of all those cubes/ODS/queries which are not used. May be these are just being loaded but not used/accessed by any queries.We want to clean up the system, so we are doing all this.

I understand that for ODS this may not be true as data would be going to cube or so.

But from which table/ report I would get info tht this cube was last accessed by query on this date?

I think for queries we can use RSRREPDIR - ?

Thanks

Gaurav

All help appreciated and rewarded by points...