Show Alias in SUBNM formula via TM1 WEB
Posted: Mon Apr 15, 2013 12:36 pm
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!
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!
