sorry for the simple question, as I am new in TM1.
Thanks in advance...
How to Delete a Cell Security Cube?
- 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?
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
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
- 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?
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.
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.
-
- 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?
Easy!
by TI-Process. command CubeDestroy, more details in Reference Guide
by TI-Process. command CubeDestroy, more details in Reference Guide
-
- 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?
@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.
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.
-
- 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?
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?
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?
-
- 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?
I would just make a quick TI process that says
CUBEDESTROY('}CellSecurity_YOURCUBENAME');
CUBEDESTROY('}CellSecurity_YOURCUBENAME');