Element Security

[darners]

I am having some issues with Element Security

I have a cube that has 4 Dimensions

Row:

Title & Input Type

Column:

Months

Context:

Revision Number

I have set dimension Security to be WRITE for all Dimensions

I have set Element Security for the Months Dimension to be READ or WRITE depending on the current Month
I have set Element Security on the Input Type Dimension to be WRITE (Next Forecast) and READ for all others

My problem is that the element security for Input Type is working fine but not for the Months Dimension as per attached Screenshot

any help Gratefully received

Screen Shot 2016-04-19 at 10.00.39.png (29.63 KiB) Viewed 5396 times

Screen Shot 2016-04-19 at 10.00.07.png (27.04 KiB) Viewed 5396 times

[jim wood]

For a starter for ten you shouldn't be setting security for the admin groups as it will be ignored anyway.

[mvaspal]

Hi

Which user group does your user belong to (when doing the screenshots)?
Are there any rules applied in this cube?

[darners]

User belongs to RFC\Testing

No rules on cube

[declanr]

Your security cube write/reads are all grey suggesting they have been specified by a rule. If thats correct have you ran a security refresh after the rule was applied?

[darners]

Your security cube write/reads are all grey suggesting they have been specified by a rule. If thats correct have you ran a security refresh after the rule was applied?

Sorry , pretty new to this, I do have rules on the cube which set READ or WRITE based on a control cube, (but before I added this and I manually set the security I was still having the same issue)

I have set this under

Model Security - Cubes - ElementSecurity_CubeName

['Mar OR'] = S:
IF ( DB ('RFC - Control','Read Only Months','Value') @>= '01','READ','WRITE');
['Apr OR'] = S:
IF ( DB ('RFC - Control','Read Only Months','Value') @>= '02','READ','WRITE');
['May OR'] = S:
IF ( DB ('RFC - Control','Read Only Months','Value') @>= '03','READ','WRITE');
['Jun OR'] = S:
IF ( DB ('RFC - Control','Read Only Months','Value') @>= '04','READ','WRITE');
['Jul OR'] = S:
IF ( DB ('RFC - Control','Read Only Months','Value') @>= '05','READ','WRITE');
['Aug OR'] = S:
IF ( DB ('RFC - Control','Read Only Months','Value') @>= '06','READ','WRITE');
['Sep OR'] = S:
IF ( DB ('RFC - Control','Read Only Months','Value') @>= '07','READ','WRITE');
['Oct OR'] = S:
IF ( DB ('RFC - Control','Read Only Months','Value') @>= '08','READ','WRITE');
['Nov OR'] = S:
IF ( DB ('RFC - Control','Read Only Months','Value') @>= '09','READ','WRITE');
['Dec OR'] = S:
IF ( DB ('RFC - Control','Read Only Months','Value') @>= '10','READ','WRITE');
['Jan OR'] = S:
IF ( DB ('RFC - Control','Read Only Months','Value') @>= '11','READ','WRITE');
['Feb OR'] = S:
IF ( DB ('RFC - Control','Read Only Months','Value') @>= '12','READ','WRITE');

[declanr]

Having rules is fine but you need to make sure that you apply a security refresh after they change.

This can be done by the TI function SecurityRefresh or right clicking on the aerver in architect and selecting to refresh security manually.
Until that is done the changes won't apply... with the exception of cellsecurity cubes where the rules apply automatically.

[darners]

Having rules is fine but you need to make sure that you apply a security refresh after they change.

This can be done by the TI function SecurityRefresh or right clicking on the aerver in architect and selecting to refresh security manually.
Until that is done the changes won't apply... with the exception of cellsecurity cubes where the rules apply automatically.

Excellent thanks you, it was the 'Refresh Security' - Newbie error