TM1ELLIST syntax to get alias

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

[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?

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

[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 ";"

[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.)