StrToMember (MDX)

Returns a member after evaluating the string expression.

In our example, we converts "[Geography].[Geo].[Paris]" to a member.

Query

StrToMember('[Geography].[Geo].[Paris]')

Result

{ 
  [Geography].[Geo].[City].[Paris]
}

Assertion : Cell Equals

[Geography].[Geo].[Paris]

The parameter string can be any valid expression containing MDX functions.

In our example, we converts "[Geography].[Geo].[France].children(0)" to a member.

Query

StrToMember('[Geography].[Geo].[France].children(0)')

Result

{ 
  [Geography].[Geo].[City].[Paris]
}

Assertion : Cell Equals

[Geography].[Geo].[Paris]

If the CONSTRAINED flag is present, the string has to match an existing member's name; no evaluation is performed.

Query

StrToMember( '[Geography].[Geo].[New York]', CONSTRAINED)

Result

{ 
  [Geography].[Geo].[City].[New York]
}

Assertion : Cell Equals

[Geography].[Geo].[New York]

Using functions is not authorized with the CONSTRAINED flag.

Query

StrToMember( '[Geography].[Geo]', CONSTRAINED)

Result

Error Code    : OLAP_CONSTRAINED_VIOLATED
Error Message : StrToMember() : the restrictions imposed by the CONSTRAINED flag were violated.

Returns NULL if applied to a NULL entity.

Query

WITH
    MEMBER [Measures].[V] AS StrToMember(NULL)
SELECT
    [Measures].[V] ON 0
FROM
    [Sales]

Result

Error Code    : OLAP_MDX_EXPRESSION_EXPECTED
Error Message : StrToMember() : expression expected : received a null/empty string expression.