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

    Returns a hierarchy caption from a given hierarchy unique name.


    XL3HierarchyLookup( Connection, Hierarchy )


    Parameter Description
    Connection Connection number to use
    Hierarchy Unique name of the hierarchy to retrieve the caption for

    Examples (based on the Bicycle Sales cube)

    Returns 'Product', the caption of the [Product] dimension.

    =XL3HierarchyLookup( 1, "[Product]" )

    See Also