INFOR.GET.LEVELS

This function returns requested schema properties for specified parameters.

INFOR.GET.LEVELS supports dynamic arrays. The returned values are spilled to the adjacent cells.

Syntax

The function has this syntax:

=INFOR.GET.LEVELS("spillByColumns", "data_connection", "cube", "dimension", "hierarchy"{, ["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.
hierarchy	The unique name of the hierarchy or a cell reference.
`schema_property`	Matrix of strings or cell references that represents properties to be returned. Optional parameter with the default value: "" that returns all fields. These values can be used: caption Returns the display name of the level. unique_name Returns the unique name of the level and can be used in formulas. description Returns the description of the level. cardinality Returns the number of elements. level Returns the level number. parent Returns the unique name of the hierarchy that contains the level. MDSCHEMA_LEVELS rowset

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