Unable to destroy Cell Security cube

Post Reply
jamesbennett
Posts: 28
Joined: Wed Aug 08, 2018 10:01 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2016

Unable to destroy Cell Security cube

Post by jamesbennett »

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?
Wim Gielis
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

Post by Wim Gielis »

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
jamesbennett
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

Post by jamesbennett »

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.
Wim Gielis
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

Post by Wim Gielis »

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.
Show us the code please.
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
jamesbennett
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

Post by jamesbennett »

Wim Gielis wrote: Mon Jan 20, 2020 11:22 am Show us the code please.

Code: Select all

CellSecurityCubeDestroy('}CellSecurity_Allocations');
As mentioned it's in the Prolog tab of the TI, Data Source set to None.
Wim Gielis
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

Post by Wim Gielis »

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.
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
jamesbennett
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

Post by jamesbennett »

I see - obvious when you point it out. Thanks for your help, that works well now.
Post Reply