LinkMember (MDX)

Returns the member in the new hierarchy matching the specified member key.

In our example, we return the [United States] of the hierarchy [Economy].

Query

LinkMember([Geography].[Country].[United States],[Geography].[Economy])

Result

{ 
  [Geography].[Economy].[Country].[United States]
}

Assertion : MDX Equals

[Geography].[Economy].[United States]

Assertion : Cell Equals

// LinkMember is using the member key in the 'new' hierarchy
StrToMember( '' + [Geography].[Economy].uniqueName + '.&[' + [Geography].[Country].[United States].PROPERTIES("KEY") + ']' )

Returns NULL if there is no matching member in the specified hierarchy.

In our example, the level [Continent] does not exist in the [Economy] hierarchy.

Query

LinkMember([Geography].[Continent].[Europe],[Geography].[Economy])

Result

NULL

Returns NULL if the member and the hierarchy are from a different dimension.

Query

LinkMember([Geography].[Country].[United States],[Time].[Calendar])

Result

NULL

Returns null when applied to a null member.

Query

LinkMember(null,[Geography].[Geo])

Result

NULL

The hierarchy must be specified.

Query

LinkMember([Geography].[Country].[Spain],null)

Result

Error Code    : OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH
Error Message : LinkMember() : argument (1) type mismatch: expected:'hierarchy', got:'NULL'

Returns an error if applied to an invalid type.

Query

LinkMember([Geography].[Country].[Spain])

Result

Error Code    : OLAP_FUNCTION_UNEXPECTED_ARGUMENT_COUNT
Error Message : LinkMember() : unexpected number of parameters '1' (expected:'2,2')