Edit

Share via

MemberToStr (MDX)

  • Article

Returns a Multidimensional Expressions (MDX)-formatted string that corresponds to a specified member.

Syntax

  
MemberToStr(Member_Expression)

Arguments

Member_Expression
A valid Multidimensional Expressions (MDX) expression that returns a member.

Remarks

This function returns a string containing the uniquename of a member. It is usually used to pass a member's uniquename to an external function.

Example

The following example returns the string [Geography].[Geography].[Country].&[United States] :

WITH MEMBER Measures.x AS MemberToStr  
([Geography].[Geography].[Country].[United States])  
SELECT Measures.x ON 0  
FROM [Adventure Works]

See Also

MDX Function Reference (MDX)