Show Alias in SUBNM formula via TM1 WEB

[KimTM1]

Hi dear helpers,

I have a SUBNM formula in an Excel sheet where I use a Subset and an alias.
=SUBNM("server:dimension";"Subsetname";"1133 / Customername")
If I access this sheet via TM1 web the alias is gone and only the elementname shows up.
1133 instead of "1133 / Customername". When I open up the Dimension in the subsetviewer via the SUBNM formula the whole list with customers only show numbers. No Descriptions.
I know that I can change the setting in the little subsetview window in the web to show the alias. But that's not what I need. I need to show the alias right from the beginning.
Isn't it possible?
Am I doing anything wrong? Any Workaround?
We use TM1 web 10.1
Any help appreciated
Thank you very much!

[declanr]

Code: Select all

SUBNM("server:dimension","subsetname","element name","alias name")

[KimTM1]

Oh no!!! So easy... ! Embarrassing I haven't found out myself!
Thank you so much. That helped a lot!!!