INFOR.GET.DIMENSIONS

This function returns requested schema properties for specified dimensions.

INFOR.GET.DIMENSIONS supports these features:

Syntax

The function has this syntax:

=INFOR.GET.DIMENSIONS("spillByColumns", "data_connection", "cube" {, ["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.
`schema_property`	Matrix of strings or cell references that represents properties to be returned. Optional parameter with the default value: "" that returns all fields except `MDSCHEMA_DIMENSIONS`, which needs to be queried explicitly. These values can be used: caption Returns the display name of the dimension. unique_name Returns the unique name of the dimension. description Returns the description of the dimension. default_hierarchy Returns the unique name of default hierarchy if available. parent Returns the unique name of the cube that contains the dimension. MDSCHEMA_DIMENSIONS rowset

This function returns the specified schema properties for all available dimensions for the specified data connection and cube.