Problem with Security Cube setting

[kennyyeung]

I have a dimension level Security Cube
}ElementSecurity_Customer

I granted the corresponding right to the client Sales1 .
So that Sales1 can view and edit the Cube. [Attached screen shot]

I can manually update the cube with READ , WRITE ,ADMIN ,LOCK...etc
However , if i create a proccess to cellPuts the value , the following error exist

Code: Select all

CellPutS ('READ','}ElementSecurity_Customer','Others_228','Sales1');

Error: Prolog procedure line (5): Execution was aborted. No Security Access for "CellPutS".

Did anyone try this before ?

[kennyyeung]

solved
just right click the proccess tick security access

[paulsimon]

Ken

You could also try ElementSecurityPut. As you probably know values in security cubes always don't take effect immediately. You are probably safe enough writing a value in to the cube, but a rule derived value generally requires a SecurityRefresh before it becomes active. The slightly odd thing about ElementSecurityPut is that, at least in 9.1.4 it appears to create the security, eg if you use the Element Security Dialog Box, you can see the effect of it, however, if you view the }ElementSecurity cube, the cell appears blank. I tended to do an ElementSecurityPut to be sure that the security will take effect immediately, and then do an ElementSecurityGet and a CellPutS of the value in to the ElementSecurity cube so that I can see the current situation whichever way I decide to view security.

Regards


Paul Simon