Page 1 of 1
TM1ELLIST syntax to get alias
Posted: Tue Jul 14, 2020 8:48 pm
by Paul Segal
I'm have a senior moment trying to get this to work. I can get the array back, but I want to use a different alias. This just returns the base name, and I can't figure out why.
Code: Select all
=TM1ELLIST("JCG:COMPANY","Data Expected",,"Number and Name")
where Number and Name is the alias.
I've also tried
Code: Select all
=TM1ELLIST("JCG:COMPANY","Data Expected","","Number and Name")
Any help appreciated.
Re: TM1ELLIST syntax to get alias
Posted: Wed Jul 15, 2020 7:37 am
by Elessar
Hi,
There was an issue in early PAX and PA versions with aliases in TM1ELLIST, which was corrected. What are your PAX/PAW/PA versions?
Re: TM1ELLIST syntax to get alias
Posted: Wed Jul 15, 2020 9:15 am
by Paul Segal
PAX is 11.0.54.6, PAW is 2.0.53 and PA is 11.6, but I've tested it on PA 11.7 and I'm still just getting the base element back.
Re: TM1ELLIST syntax to get alias
Posted: Wed Jul 15, 2020 11:29 am
by Elessar
I've never used it with subsets, only with MDXes. The correct syntax is:
Code: Select all
=TM1ELLIST("Server:Dimension";;;"Alias";;"MDX";;)
You should first try to replace your commas with ";"
Re: TM1ELLIST syntax to get alias
Posted: Wed Jul 15, 2020 12:49 pm
by Paul Segal
I raised a ticket and IBM support say it's a bug, and one they're not going to fix. I've figured out a workaround, but it's -ah- disappointing that IBM shipped it with this error. (Although, just to reiterate: the function works, it just won't return an alias against subset members.)