I've been using ADOMD Command Designer and am switching over to MDX Studio and am having trouble getting member names to show. In ADOMD, I could use DIMENSION PROPERTIES MEMBER_NAME ON ROWS and aliases would be returned. By commenting out this line, I could get both names and aliases to show.
In MDX Studio, I only get aliases.
I've tried MEMBER_ALIAS, but that dimension attribute isn't found. I also tried MEMBER_CAPTION, but that didn't change the results.
nonempty ( [Year].)
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
DIMENSION PROPERTIES MEMBER_NAME ON ROWS
WHERE ([Currency].[USD], [Measures].[Amount], [Entity].[BHI], [Value].[All values], [Period].[Jul])