Change Display Alias based on a Dimension

Post Reply
fbroggi
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

Post by fbroggi »

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
Attachments
Cattura.JPG
Cattura.JPG (28.96 KiB) Viewed 5305 times
User avatar
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

Post by mattgoff »

ATTRS
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
fbroggi
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

Post by fbroggi »

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)
User avatar
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

Post by mattgoff »

=ATTRS("yourserver:yourdimension",$A2,$A$1)

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.
fbroggi
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

Post by fbroggi »

Thanks,
but I have to write this on rule or where?

Federico
User avatar
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

Post by qml »

This is an example of an Excel formula that will work in an Excel worksheet. :roll:
Kamil Arendt
jstrygner
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

Post by jstrygner »

I am affraid ATTRS is TI and Rules function only.
Use DBRA in worksheet.
User avatar
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

Post by mattgoff »

Oops. :?
Please read and follow the Request for Assistance Guidelines. It helps us answer your question and saves everyone a lot of time.
fbroggi
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

Post by fbroggi »

Many thanks for all the advice

Federico
Post Reply