XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

XL3HierarchyLookup

Revision as of 10:35, 8 October 2010 by Antonio.remedios (talk) (Added categories)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Returns a hierarchy caption from a given hierarchy unique name.

Syntax

XL3HierarchyLookup( Connection, Hierarchy )

Parameters

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

Retrieved from ‘https://help.xlcubed.com/index.php?title=XL3HierarchyLookup&oldid=143’