How can we find out Dimension table is in use ?

Hi All

How can we findout the dimension table exists in the cube are fine tunning (in use) or not?

and also aggregates are fine tuning or not

Regards

Balji