TM1 Forum

Hi All,
I have encounter a problem of setting the access right of element.
For example i have two dimension one have the elements:plan,actual,
Another dimension have the elements like:last year,current year,next year
if i want the last year only show the actual in next level, and current year and next year have both plan and actual element in next level
How can i realize the function?
I have used the rule like:
['last year','plan']=S:'None';
It only make the cell none, but the plan element is still displayed on the viewer of last year.
Who can give me some help?
Thank You

keigo840413 wrote:Hi All,
I have encounter a problem of setting the access right of element.
For example i have two dimension one have the elements:plan,actual,
Another dimension have the elements like:last year,current year,next year
if i want the last year only show the actual in next level, and current year and next year have both plan and actual element in next level
How can i realize the function?
I have used the rule like:
['last year','plan']=S:'None';
It only make the cell none, but the plan element is still displayed on the viewer of last year.
Who can give me some help?
Thank You

I'm assuming that you mean something like this, where the viewer should be able to see the green columns but the yellow column doesn't appear: There's no easy way to do that with security and TM1 doesn't really support "asymmetric" views of that type. The easiest way is to zero out the data (or clear it; I'm not certain whether this is supposed to be string or numeric data given that you tried to use an S: rule) which will prevent the column from appearing when zero suppression is on.

If you want to keep the data so that it can be compared for historical purposes, rather than zeroing it out consider creating a new element in the first dimension called Former Plan, and move the Last Year element's Plan data into there. That way you'll only see the last year plan data if you really want it to appear.

yes Alan, i have also though about zero suppress, but it will also hide the column whose value is zero but should be shown...
I just wonder whether there have some common ways to do that

keigo840413 wrote:yes Alan, i have also though about zero suppress, but it will also hide the column whose value is zero but should be shown...
I just wonder whether there have some common ways to do that

If you're particular about "want this column but not that column but this column as well" you'd be better off not doing this as a view at all; better to use either an Excel report or websheet, as the case may be.