TM1 Forum

Hi

I was recently replacing cube element security rules with TI processes, this is the first time I have done this.

I note that I kept getting errors when writing to ADMIN groups, the errors kept telling me that I was trying to write to a consolidated element (sorry, going off memory), and yet all elements in the }Groups dimension, including the ADMIN elements are strings.

And I couldn't seem to avoid the errors with the usual If(CellisUpdatable) thing

Any ideas?

How are you writing to the }ElementSecurity_<dim> cubes, with CellPutS or with ElementSecurityPut? Since a specific function exists to get and set element security better to use it. Of course with cube security or cell security there's no other option but CellPutS ...

Also you might as well ItemSkip the groups ADMIN, DataAdmin & SecurityAdmin as security for these is built-in and can't be overwritten either via rules or entry to the security cubes.

Other than that please follow the posting guidelines and post your code otherwise any assistance is really just a stab in the dark.

Fair enough re the code, I was offsite when I posted and didnt have access

Here is my amended code; it now works thanks to your advice

I kept the CellPutS as I had created about 15 of these all based on the control cube as datasource and going back to change all of the processes to use dimension datasouce and ElementSecurityPut was all too much work, but I will know for next time

#Original rule
#[]=S:
#IF(
#SUBST(!}GROUPS,1,3) @= 'HR_',
#'WRITE',
#'NONE');

If(vGroup @= 'ADMIN' % vGroup @= 'DataAdmin' % vGroup @= 'SecurityAdmin');
ITEMSKIP;
EndIf;

If( SUBST(vGroup,1,3) @= 'HR_');
CellPutS('WRITE', sCubeName, vHR_CCSecurityList, vGroup);
Else;
CellPutS('NONE', sCubeName, vHR_CCSecurityList, vGroup);
EndIf;