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
Deleting Unused control cubes
- 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
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
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
Jodi Ryan Family Lawyer