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

[Former Member]

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...

[former_member188975]

Hi Gaurav,

You can check table RSDDSTAT...

[Former Member]

Hi Bhanu,

Thanks for reply!

I checked RSDDSTAT but description out there is : Obsolete as of Release BI 7.0 -> RSDDSTAT_OLAP/DM" so I checked both RSDDSTAT_OLAP and RSDDSTAT_DM tables.

I am not sure what does data means in these tables:

In Table "RSDDSTAT_OLAP", i checked for one cube which is not used and its data has been deleted but in RSDDSTAT_OLAP-BW Stats: Day its showing me 10/10/2006..?

Can you help me in understanding about how to interpret these tables?

Is there any report you know which gives me this info?

Statistics have been installed in system and I m at 2004s.

Thanks a ton

Gaurav

"

[former_member188975]

Hi Gaurav,

If you have BW Statistics installed, take a look at this one:

http://help.sap.com/saphelp_nw2004s/helpdata/en/de/472a3cf3e23610e10000000a11402f/content.htm

Hope this helps...

[Former Member]

Hi Bhanu,

Here new Statistcis have also been installed ( 0TCT*).

I checked query which you mentioned, its precisely what I want but tht cubes upon which query is based have not been uploaded.

I am not sure why this is so.

Can we use old and new statistics in conjunction? because new stat cubes are uploaded but not old one (0BWTC*).

Would data get duplicated if we load both?

Thanks again for help and your time,

Gaurav