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 - ?
All help appreciated and rewarded by points...