Deleting Unused control cubes

Post Reply
Darkhorse
Posts: 141
Joined: Wed Mar 09, 2011 1:25 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2003 2007 2010 2013

Deleting Unused control cubes

Post by Darkhorse »

Hi all

Is there any program created to remove Control cubes that have had there main cubes deleted from the file store?

Im searching through the directory and im finding security cubes and attribute cubes still there from old deleted projects, I have a program that removes unlinked dims, is there a way to find unlinked control cubes?

thanks as all ways
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Deleting Unused control cubes

Post by Martin Ryan »

If you use the front end then control cubes should get deleted when their master is deleted. For example when you delete the Month dimension the associated }ElementAttributes_Month cube and dimension will also get deleted.

However if the master is deleted in the back end (e.g. month.dim is deleted from the data directory) then you'll end up with floaters. In my example the }ElementAttributes_Month.cub cube won't load because the absence of the Month.dim means it can't load, but the }ElementAttributes_Month.dim file will still load. You could use something like this process to identify them.

But as for the floating .cub files you'll just have to run through the data directory and work them out for yourself. The output of the above mentioned process might at least point you in the right direction because it will point out the floating control dimensions, so you can look for their cube counterparts.

HTH,
Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Post Reply