Security driven perspectives activeform cell values

[smish]

Hi all,

newbie here. Need some help with this scenario:

We have a sector dimension which contains: Public, Financial, Industrial as elements.

Security:
Client names: Public, Financial, Industrial, Sector_Top
Security groups: Public, Financial, Industrial, Sector_Top.

(yes, we like to keep things consisent )

In a TM1 perspectives excel activeform we display sector based on who is logged in using this formula in a cell:

=SUBNM("PerfCube:Sector_Industry","Level1",UPPER(TM1USER($C$8))) <-- $C$8 is in format area, value=PerfCube

User "Financial" logs into TM1 Web and value of Sector = Financial and only returns data for that sector...great - exactly what we want!
However, for Sector_Top users - no data is returned. We want to return all possible values of sector
from which Sector_Top user can select a value from ie Public, Financial, Industrial. This is where my
lack of experience comes in.

Any ideas much appreciated.

Regards,

Smish

[declanr]

I assume that although it defaults to a blank cell the user is still able to use the drop down to select one of the elements?

There are a number of ways you could do this but since your user structure simply aligns and what you are already doing already works for 75% of cases you may as well just make a small tweak to what you already have instead of any big changes;
you could just add an IF statement around the user so that if the TM1User function returns "Sector_Top" then it will put a 1 into the SUBNM (which would bring back the first element in the "Level1" subset) and otherwise leave it doing what it already does.

[smish]

Hi Declan,

yes, the sector drop down is available in TM1 Web (for all users) and adding that IF statement worked a treat!

Thanks & regards,

Smish