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:
|
Return values
This function returns schema properties for all available hierarchies for the specified data connection, cube, and, optionally, the dimension.