CELLPUTS on Security Cube vs ElementSecurityPut

[aagrawal12]

Hi,

As I have read on other link of forums that if you have Cellputs on security cube you need to do a security refresh whereas if u use Element SecurityPut u dont need to.
I am updating diemsnion security with Cellputs and even if I dont run Securityrefresh I see the access granted to the users.
I just wanted to be sure because I dont want any problems in the future and has anything change in 10.2.2 in terms of security because IBM documents particulary dont explain any of this.

Thanks,
Abhi

[jim wood]

What you need to do is compare both methods. Which one to choose can differe based on the number of security groups you have, how they are applied and the number of updates you need to make in a process. As the secuity put does a mini security refresh each time. If the group / user you're updating has an impact on many security junctions (elements, cubes etc) then you may find this is really slow. The cellput in to teh control cube takes no time but the refresh at the end can take some time.

As I said I would try both on a copy of production is say your dev environment and see which one is quicker,

Jim.

[aagrawal12]

Thanks Jim but I wanna know if you need to do SecurityRefresh or Cellput on security cube would take care by itself, because I see my security is updated even if I dont do security refresh when I am using cellput on security cube.

[mattgoff]

I'm going to guess that ElementSecurityPut is a redundant function to CellPutS('}ElementSecurity_dimname',...) in the same manner that AttrPutS is redundant to CellPutS('ElementAttribute_dimname'....). So, you're probably going to need a SecurityRefresh whenever you alter the security cubes in any way other than via the security GUI (i.e. directly changing the cube via the cube viewer or TI). SecurityRefresh is a very inexpensive function, so either way just put one in and call it a day.

Matt

[dwigsy]

The CellPutS should work fine. If there are any rule based security settings based on the hard data you will need the securityrefresh and / or you may see a difference between the two methods.

[Gabor]

You shouldn't need to "Refresh Security" as long as you don't use Rules in Element Security.