Security

[cherry4]

I have requirement where i need to Create a Account Security cube with Location/Accounts. Include all accounts and all loactions. There should be a total line and a picklist that is either blank field or "Read".
when i gave location i got an error so i just took accounts that too single account element in account dimension which got read permission
but they need location and account now
Skipcheck;
Feedstrings;


[{'CAMID(":TM1:Custom Data:Custom Data Admin")','ADMIN','SecurityAdmin','DataAdmin'}]=STET;

[{'40100',
'41360',
'41365',
'41370',
'41390',
'41960',
'42000',
'42560',
'42600',
'42610',
'42620',
'42710',
'42750',
'42770',
'43770',
'43811',
'43812',
'43830',
'43850',
'43860',
'43880',
'45570',
'45575',
'45600',
'47160',
'47200',
'47210',
'47220',
'47760',
'47761',
'47860',
'46240',
'42630',
'42640',
'42650',
'42660',
'42720',
'42820',
'40416',
'40417'}]=S:IF(DB('Account Security',!Accounts,'Security Flag')@= 'Y','WRITE','READ');
But i need to write a rule for location and account.can any one please help

[rmackenzie]

But i need to write a rule for location and account.

I assume your posted code is for an Element security cube, right? Perhaps, you need to look at Cell security instead?