TM1 Forum

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

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.

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