tracing dimension use by cube

Post Reply
winsonlee
Regular Participant
Posts: 180
Joined: Thu Jul 01, 2010 3:06 am
OLAP Product: Cognos Express
Version: 9.5
Excel Version: 2007
Location: Melbourne, Australia

tracing dimension use by cube

Post by winsonlee »

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 ?
winsonlee
Regular Participant
Posts: 180
Joined: Thu Jul 01, 2010 3:06 am
OLAP Product: Cognos Express
Version: 9.5
Excel Version: 2007
Location: Melbourne, Australia

Re: tracing dimension use by cube

Post by winsonlee »

http://www.tm1forum.com/viewtopic.php?f=21&t=4901

i think i found the answer.
will try that out.
Post Reply