tracing dimension use by cube
Posted: Sat Nov 26, 2011 12:28 am
I remember i see this in the forum but somehow i couldnt find the post.
I would like to find out a list of cube used by a dimension.
eg
time_dimension cube 1
time_dimension cube 2
time_dimension cube 3
measure1 cube1
measure1 cube4
measure1 cube5
i would like to find out a list of dimension that is not being used by any cube so that i can remove it.
can this be done in tm1 tools ?
I would like to find out a list of cube used by a dimension.
eg
time_dimension cube 1
time_dimension cube 2
time_dimension cube 3
measure1 cube1
measure1 cube4
measure1 cube5
i would like to find out a list of dimension that is not being used by any cube so that i can remove it.
can this be done in tm1 tools ?