Remove the alias in MDX of dimension; show member ID

[Paul-TM1]

Hi All,
By default, when a dimension is opened, alias with name is coming and am trying to remove.
In PAW, I was able to select "Member ID" from dropdown and it's static thought I saved. When I reopened the subset, the alias turned on.
What MDX should be added to remove alias. I am sure this was discussed and can someone direct me to that post?

This is the MDX. I want to remove alias name and show just member ID.

Code: Select all

DESCENDANTS(
	TM1FILTERBYPATTERN(TM1SUBSETALL([Projects]) , "2 - FPA") 
	, 2)

Thanks,
Paul.

[MarenC]

Hi,

You are a bit light on information, for example, are we to assume that 2 - FPA is an alias?

If so, this could help

DESCENDANTS(
TM1FILTERBYPATTERN(TM1SUBSETALL([Project]) , "2 - FPA","Whatever the Alias is called")
, 2)

Maren

[Paul-TM1]

Thanks Maren, it did not help.

"2 - FPA" is not an alias. It's ID.

Again, I want to remove name that comes with alias in the list after committing MDX.

Thanks,

Paul.

[Wim Gielis]

I am very sorry but I don't understand it.
A few pictures might make it clearer.

[lotsaram]

You can just select another alias to display or switch off alias in the GUI?!

From a query perspective the MDX always returns the member names (without alias). The display of an alias is a function of the GUI. If you are looking in MDX to disable alias display you're looking in the wrong place.

[Paul-TM1]

Thanks Lotsaram.
In the set editor in PAW, in the dropdown of caption when I select member Id, member ID is displayed. I saved the subset thinking it would keep the member Id, but it's not. When open the subset, alias is back.

Any idea on what should be done to just get the member Id from the MDX?

Thanks,
Paul.

[Wim Gielis]

Saving a subset should also save the alias or principal name choice.

[Paul-TM1]

Hi Wim,
Thanks for replying.
Saving the subset without the name seemed to help the day1, but when we opened the next day, or added the subset to another view, the name appears.
The list in the subset is created using MDX and I am looking for a MDX solution.

Thanks,
Paul.

[MarenC]

If you are creating this from a TI process, which you might have mentioned from the start, then you can check is SubsetAliasSet is being used.


Maren