INFOR.GET.ATTRIBUTES

This function returns requested schema properties for specified dimensions.

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

Syntax

The function has this syntax:

=INFOR.GET.ATTRIBUTES("spillByColumns", "data_connection", "cube", "dimension", "hierarchy" {, "level", ["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.
level An optional parameter that represents the unique name of the level or a cell reference. If specified, only attributes for the selected level are returned.
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 attribute.

  • unique_name

    Returns the unique name of the attribute and can be used in formulas.

Return values

This function returns schema properties for all available attributes for the specified data connection, cube, dimension, and hierarchy. If the level is specified, only attributes that are specific for that level are returned.