An MDX Question?
OLAP Server User Guide
Configuring icCube
Running icCube
Migrating icCube
Security
Creating Schemas/Cubes
Working with icCube
Reporting Tools Integration
Embedding icCube
Plugins/Extensions
Web Reporting
Installation
Local Settings
Visualization Library
Tutorials
Demos
MDX Documentation
MDX Tutorial (Gentle Introduction)
MDX Functions Reference
MDX Language Reference
Reference
icCube Client Library
XMLA Client Library
LookupByKey (icCube MDX extension)

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

Parameters

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

Return

member

Description

The function returns the first member matching the key specified in the value expression.

If a hierarchy is specified the algorithm will start at the first level and continue until a matching member is found.

It is similar to strToMember("Level-expresssion" + "&[" + value-expression + "]") function, but faster and specially useful when the key is a date or a time object.

See Also

strToMember

Examples

LookupByKey(level,key)
LookupByKey(hierarchy,key)
LookupByKey(level,key) - member not found

XMLA Properties

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

icCube OLAP version: 2.5.1 13-May-2012 02:21:10 GMT