}CellSecurity_CUBENAME

[Ajay]

Hi All

I am currently running into a few security issues concerning a version and month dimension inside one of my cubes.

Currently need the Budget open for 12 months but need to only open the Actuals for one of the months, however short of giving users a seperate login (one for actuals and one for budget) I'm looking at perhaps using the }CellSecurity_CUBENAME functionality.

Any tips or cautionary words on using these types of cubes. Seems like there is alot for me to fill in !!

Cheers
Ajay

[David Usherwood]

I deal with this by creating a little cube 'OpenYearMonth' writable by admin, with 1s for open y/m combos, then in the cell security cube the rule is
['Actual'] = s: if(db('OpenYearMonth',!Year,!Month) = 1,
'WRITE',
#else
'READ'
);

You likely need to refine where it applies.
I've read posts saying that cell security is a performance overhead but not found that myself.
(Written in the departure lounge in Cairo)