icCube

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.

See Also

LookupByKey LinkMember StrToMember

Examples

Since Version

7.3

XMLA Properties

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