Sorry for foolish question, i'm new.
I write cell security. If i write rule in :
['element1']='READ'; (for example time dimension)
['element2']='WRITE'; (for example some user group)
[]='READ';
['ELEMENT3']=UNDER SOME CONDITIONS 'WRITE','READ';
Means this that element1 is every time read?, Element 2 every time write, element 3 read or write, rest of the cube is read? Regardless order how rules are writen?
But what about intersection in cell element1xelement2?
Question about rules
-
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Question about rules
sun wrote:Sorry for foolish question, i'm new.
I write cell security. If i write rule in :
['element1']='READ'; (for example time dimension)
['element2']='WRITE'; (for example some user group)
[]='READ';
['ELEMENT3']=UNDER SOME CONDITIONS 'WRITE','READ';
Means this that element1 is every time read?, Element 2 every time write, element 3 read or write, rest of the cube is read? Regardless order how rules are writen?
But what about intersection in cell element1xelement2?
Cell security can be very hard to maintain even for experienced TM1 Administrators, so I would take it back to the drawing board and see whether you could achieve your desired security by using element applied security instead of cell level.
As to your question here:
If the first statement in a rule applies to a cell (we will call it cell X)
The second statement in a rule also applies to cell X
The first rule will be enacted and the second rule ignored (for that cell)
So the intersection of Element1 and Element 2 in your example would be 'READ'.
Declan Rodger
-
- Posts: 51
- Joined: Thu Feb 02, 2012 8:21 pm
- OLAP Product: TM1 Cognos
- Version: 9.5
- Excel Version: 2003
Re: Question about rules
Thank you for replay.
SO in this case, as i wrote... Becasue i have
[]='READ';
and then
['ELEMENT3']=UNDER SOME CONDITIONS 'WRITE','READ';
Second rule has no effect?
tnx
Regards
SO in this case, as i wrote... Becasue i have
[]='READ';
and then
['ELEMENT3']=UNDER SOME CONDITIONS 'WRITE','READ';
Second rule has no effect?
tnx
Regards
-
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Question about rules
You are correct.sun wrote:Thank you for replay.
SO in this case, as i wrote... Becasue i have
[]='READ';
and then
['ELEMENT3']=UNDER SOME CONDITIONS 'WRITE','READ';
Second rule has no effect?
tnx
Regards
[]='READ'; renders any subsequent statements useless.
Declan Rodger