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.
SELECT
nonempty ( [Year].[2010])
DIMENSION PROPERTIES MEMBER_NAME ON COLUMNS,
([Account].[110-411-000-990], [scenario].[actual])
DIMENSION PROPERTIES MEMBER_NAME ON ROWS
FROM [consolidations]
WHERE ([Currency].[USD], [Measures].[Amount], [Entity].[BHI], [Value].[All values], [Period].[Jul])
Sorry if this is too vague. It's my first post.
