LookupByKeys (MDX+)

Returns a set of members in a given level/hierarchy/dimension matching the key parameters.

Parameters

Return

set-members

Description

The function returns the members matching the keys specified in the scalar expressions. If the keys of the requested members are multi-values, then wrap each of them into a ListScalars (see example below).

See Also

LookupByKey ListScalars

Examples

LookupByKeys( [Geography].[Geo], "FR", "ES" )

{ 
  [Geography].[Geo].[Country].[France], 
  [Geography].[Geo].[Country].[Spain]
}

{ [Geography].[Geo].[France], [Geography].[Geo].[Spain] }

LookupByKeys( [Geography].[Geo], ListScalars("FR"), ListScalars("ES") )

{ 
  [Geography].[Geo].[Country].[France], 
  [Geography].[Geo].[Country].[Spain]
}

{ [Geography].[Geo].[France], [Geography].[Geo].[Spain] }

XMLA Properties

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