LookupByName (MDX+)

Returns the first member in a given level/hierarchy/member child matching the parameter name.

Parameters

Name	Type	Cardinality	Default value
	dimension-hierarchy-level-member-expression	one
	value-expression	one

Return

member

Description

The function returns the first member matching the name specified in the value expression.
Note, the lookup is done on the name and not the caption that might be localized if the schema has
localization active. Same as when writing an MDX query.

It is similar to strToMember("Level-expression" + ".[" + value-expression + "]") function, but faster and not using localization.

Examples

LookupByName(level,name)

Returns the first member in the specified level matching the specified member name.

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

Query

LookupByName([Geography].[Economy].[Country],"United States" )

Result

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

Assertion : MDX Equals

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

Assertion : MDX Equals

strToMember( "[Geography].[Economy].[" + [Geography].[Economy].[United States].name + "]" )

LookupByName(member,name)

LookupByName(level,name) - member not found

Since Version

7.3

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.