TM1 Forum

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

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