INFOR.GET.HIERARCHIES

This function returns specified schema properties for specified dimensions.

INFOR.GET.HIERARCHIES supports dynamic arrays. The retrieved values are spilled to the adjacent cells.

Syntax

The function has this syntax:

=INFOR.GET.HIERARCHIES("spillByColumns", "data_connection", "cube" {, "dimension", ["schema_property"]})

This table shows the parameters and their descriptions:


`Parameters`	Description
spillByColumns	An optional Boolean value for spill direction. Specify true to spill by columns or false to spill by rows. Default value: false.
data_connection	The unique name of the data connection or a cell reference.
cube	A cube unique name or a cell reference.
dimension	The unique name of the dimension or a cell reference. An optional parameter. If omitted, returns all hierarchies.
`schema_property`	Matrix of strings or cell references that represents properties to be returned. An optional parameter with the default value: "" that returns all fields. These values can be used: caption Returns the display name of the hierarchy. unique_name Returns the unique name of the hierarchy and can be used in formulas. description Returns the description of the hierarchy. cardinality Returns the cardinality of the hierarchy if available. parent Returns the unique name of the cube that contains the hierarchy. MDSCHEMA_HIERARCHIES rowset

This function returns schema properties for all available hierarchies for the specified data connection, cube, and, optionally, the dimension.