Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • XL3MdxLookup

    Returns the value of an MDX statement.

    Syntax

    XL3MdxLookup( Connection, MdxExpression, [Column], [Row] )

    Parameters

    Parameter Description
    Connection Connection number to use
    MdxExpression The MDX expression to run
    Column The result column to obtain the value from. 1-based, and defaults to the first column if omitted.
    Row The result row to obtain the value from. 1-based, and defaults to the first row if omitted.

    Examples (based on the Bicycle Sales cube)

    Returns the level ordinal of the product 'Mountain'

    =XL3MdxLookup( 1, "WITH MEMBER [Measures].LevelOrdinal AS 'Product.CurrentMember.LEVEL.ORDINAL' SELECT {[Measures].LevelOrdinal} ON COLUMNS, {[Product].&[Mountain]} ON ROWS FROM BicycleSales", 1, 1 )

    See Also