How to Delete a Cell Security Cube?

Post Reply
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

How to Delete a Cell Security Cube?

Post by mce »

sorry for the simple question, as I am new in TM1.
Thanks in advance...
User avatar
Michel Zijlema
Site Admin
Posts: 712
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: How to Delete a Cell Security Cube?

Post by Michel Zijlema »

Hi,

The only way to do this (AFAIK) is to stop the TM1 service, delete the cell security .cub file from the data-directory and restart the TM1 service.

Michel
User avatar
mce
Community Contributor
Posts: 352
Joined: Tue Jul 20, 2010 5:01 pm
OLAP Product: Cognos TM1
Version: Planning Analytics Local 2.0.x
Excel Version: 2013 2016
Location: Istanbul, Turkey

Re: How to Delete a Cell Security Cube?

Post by mce »

Thanks Michel.
I deleted the .cub without stopping the service and then unloaded the cube from memmory and then it disappeared.
Hope I won't have any issues with this way.
MaksimSerkin
Posts: 3
Joined: Wed Jun 16, 2010 6:27 am
OLAP Product: Cognos TM1
Version: 9.5
Excel Version: 2007

Re: How to Delete a Cell Security Cube?

Post by MaksimSerkin »

Easy!

by TI-Process. command CubeDestroy, more details in Reference Guide
Gregor Koch
MVP
Posts: 263
Joined: Fri Jun 27, 2008 12:15 am
OLAP Product: Cognos TM1, CX
Version: 9.0 and up
Excel Version: 2007 and up

Re: How to Delete a Cell Security Cube?

Post by Gregor Koch »

@MaksimSerkin

Have you actually tried this (more than once)?

I have, and I don't recommend using this approach, unless you want some very quickly ending server fireworks.

Savest to go with Michel's way.

---

The version you are on made me curious.
Wouldn't you know it. Just tried it (three times) in 9.4.1 on a Dimension Security Cube an the server held up whereas previously (9.0 and 9.1) I had instant crashes. Not that it proves much and the security seemingly persisted (as per security dialog), but hey at least it kept running.
abcuser
Posts: 133
Joined: Thu Mar 25, 2010 8:34 am
OLAP Product: Cognos TM1
Version: 9.5.2
Excel Version: 0

Re: How to Delete a Cell Security Cube?

Post by abcuser »

Hi,
I have the same problem. In my case there many files in TM1 data directory starting with the same prefix:
}CellSecurity_MyCube.cub --> probably cube file
}CellSecurity_MyCube.RUX --> probably a Rule file
}CellSecurity_MyCube.Default..blb --> probably default view
}CellSecurity_MyCube.View1..blb --> probably view1
}CellSecurity_MyCube.View2..blb --> probably view2

Should I delete all above files?

Just wondering is there really no other way using GUI that this hacking (deleting) files on server? Has someone sent feature request to IBM to implement this functionality?
clappr
Posts: 2
Joined: Thu Sep 08, 2011 4:27 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007

Re: How to Delete a Cell Security Cube?

Post by clappr »

I would just make a quick TI process that says
CUBEDESTROY('}CellSecurity_YOURCUBENAME');
Post Reply