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

    Returns a name or caption for a member in a given set.


    XL3SetLookup( Connection, SetExpression, [Position], [Format] )


    Parameter Description
    Connection Connection number to use
    SetExpression The MDX expression to run
    Position The number of the member in the set to return. 1-based, and defaults to the first member if omitted.
    Format The format to use for the returned member.
    0 Member caption (default)
    3 Member unique name

    Examples (based on the Bicycle Sales cube)

    The first region in Asia

    =XL3SetLookup( 1, "[Region].&[Asia].Children" )

    The unique name of the second child of Mountain

    =XL3SetLookup(1, "[Product].&[Mountain].Children", 2, 3 )

    See Also