MemberToStr (MDX)

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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)