I recently created a Cell Security cube via TI using the CellSecurityCubeCreate function. However, now I would like to destroy and recreate the cube as I need to include another dimension that was missed out the first time around. I have tried running another TI with the CellSecurityCubeDestroy function in the prolog - I get the message stating 'Process completed successfully' but the original cell security cube is still there, unchanged.
I note from the documentation of this function that 'The GrantSecurityAccess property must be set for this TurboIntegrator process to succeed.' Could that be preventing me from destroying the cube - how do I confirm the GrantSecurityAccess property? Or is there some other reason why this function might not be working?
Unable to destroy Cell Security cube
-
- Posts: 28
- Joined: Wed Aug 08, 2018 10:01 am
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2
- Excel Version: 2016
-
- MVP
- Posts: 3234
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Unable to destroy Cell Security cube
Did you right-click the process and set the relevant checkbox for security access ?
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 28
- Joined: Wed Aug 08, 2018 10:01 am
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2
- Excel Version: 2016
Re: Unable to destroy Cell Security cube
I hadn't - I wasn't aware of such an option - however having just ticked that I've rerun the process and get the same issue, 'Process Completed Successfully' but no impact on the cube.
-
- MVP
- Posts: 3234
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Unable to destroy Cell Security cube
Show us the code please.jamesbennett wrote: ↑Mon Jan 20, 2020 11:20 am I hadn't - I wasn't aware of such an option - however having just ticked that I've rerun the process and get the same issue, 'Process Completed Successfully' but no impact on the cube.
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 28
- Joined: Wed Aug 08, 2018 10:01 am
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2
- Excel Version: 2016
Re: Unable to destroy Cell Security cube
Code: Select all
CellSecurityCubeDestroy('}CellSecurity_Allocations');
-
- MVP
- Posts: 3234
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Unable to destroy Cell Security cube
You haven't followed the documentation by IBM:
https://www.ibm.com/support/knowledgece ... stroy.html
They have an example:
CellSecurityCubeDestroy('DataCube');
Leave out the first part of the name.
https://www.ibm.com/support/knowledgece ... stroy.html
They have an example:
CellSecurityCubeDestroy('DataCube');
Leave out the first part of the name.
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- Posts: 28
- Joined: Wed Aug 08, 2018 10:01 am
- OLAP Product: IBM Cognos TM1
- Version: 10.2.2
- Excel Version: 2016
Re: Unable to destroy Cell Security cube
I see - obvious when you point it out. Thanks for your help, that works well now.