I'd like to know if it's possible to change the alias used in a view based on a value selected in another dimension of the same cube as shown in picture attached
Many Thanks
Federico
Change Display Alias based on a Dimension
-
- Posts: 5
- Joined: Thu Nov 18, 2010 4:16 pm
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2010
Change Display Alias based on a Dimension
- Attachments
-
- Cattura.JPG (28.96 KiB) Viewed 5304 times
- mattgoff
- MVP
- Posts: 518
- Joined: Fri May 16, 2008 1:37 pm
- OLAP Product: TM1
- Version: 10.2.2.6
- Excel Version: O365
- Location: Florida, USA
Re: Change Display Alias based on a Dimension
ATTRS
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
-
- Posts: 5
- Joined: Thu Nov 18, 2010 4:16 pm
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2010
Re: Change Display Alias based on a Dimension
Thanks I know ATTRS function, my question is:
if i select an item (ex: English) in a list (ex: Language) can the account lilst change the alias dimically (ex: from Base attribute to English Attribute)
if i select an item (ex: English) in a list (ex: Language) can the account lilst change the alias dimically (ex: from Base attribute to English Attribute)
- mattgoff
- MVP
- Posts: 518
- Joined: Fri May 16, 2008 1:37 pm
- OLAP Product: TM1
- Version: 10.2.2.6
- Excel Version: O365
- Location: Florida, USA
Re: Change Display Alias based on a Dimension
=ATTRS("yourserver:yourdimension",$A2,$A$1)
A1 = name of alias
A2, A3, An = base element
I'm almost quoting the documentation here.
A1 = name of alias
A2, A3, An = base element
I'm almost quoting the documentation here.
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
-
- Posts: 5
- Joined: Thu Nov 18, 2010 4:16 pm
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2010
Re: Change Display Alias based on a Dimension
Thanks,
but I have to write this on rule or where?
Federico
but I have to write this on rule or where?
Federico
- qml
- MVP
- Posts: 1098
- Joined: Mon Feb 01, 2010 1:01 pm
- OLAP Product: TM1 / Planning Analytics
- Version: 2.0.9 and all previous
- Excel Version: 2007 - 2016
- Location: London, UK, Europe
Re: Change Display Alias based on a Dimension
This is an example of an Excel formula that will work in an Excel worksheet. 

Kamil Arendt
-
- MVP
- Posts: 195
- Joined: Wed Jul 22, 2009 10:35 pm
- OLAP Product: TM1
- Version: 9.5.2 FP3
- Excel Version: 2010
Re: Change Display Alias based on a Dimension
I am affraid ATTRS is TI and Rules function only.
Use DBRA in worksheet.
Use DBRA in worksheet.
- mattgoff
- MVP
- Posts: 518
- Joined: Fri May 16, 2008 1:37 pm
- OLAP Product: TM1
- Version: 10.2.2.6
- Excel Version: O365
- Location: Florida, USA
Re: Change Display Alias based on a Dimension
Oops. 

Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
-
- Posts: 5
- Joined: Thu Nov 18, 2010 4:16 pm
- OLAP Product: TM1
- Version: 9.5
- Excel Version: 2010
Re: Change Display Alias based on a Dimension
Many thanks for all the advice
Federico
Federico