TM1 Forum

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

ATTRS

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)

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

A1 = name of alias
A2, A3, An = base element

I'm almost quoting the documentation here.

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

Federico

This is an example of an Excel formula that will work in an Excel worksheet.

I am affraid ATTRS is TI and Rules function only.
Use DBRA in worksheet.

Oops.

Many thanks for all the advice

Federico