SSAS: Member Codes in Power Query/Pivot

[cr731]

I'm connecting to a cube through Power Query or Pivot's SSAS connector, and I'm wondering if it's possible to show the member code (not sure if that's the correct term) as opposed to the member name or description.

For example, I have a dimension "Customer," which shows me each customer's name. But I also want to return the code for each customer.

If I were to connect to the cube through a regular Excel pivot table, I can right-click on the field and choose 'Show Properties in Report' and it gives me a choice to view those other properties.

Can this be done either through PQ/PP or else by modifying the MDX somehow?

 

[cr731]

I able to make it work by adding the red text in the MDX statement, not sure if this is the best/only way?

SELECT { [Time].[Time].DEFAULTMEMBER } ON COLUMNS ,
NON EMPTY { 
{ DESCENDANTS( [Dimensions].[Cust].[All Cust], [Dimensions].[Cust].[Name] ) } * 
{ DESCENDANTS( [Dimensions].[Region].[All Region], [Dimensions].[Region].[Region] ) } } 
[B][COLOR=#FF0000]DIMENSION PROPERTIES [Dimensions].[Cust].KEY, MEMBER_CAPTION [/COLOR][/B]ON ROWS  
FROM [SALES] 
WHERE ( [Measures].[Pounds] )
CELL PROPERTIES VALUE, FORMATTED_VALUE, CELL_ORDINAL