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

Return values

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