INFOR.GET.CUBES

This function returns requested schema properties for specified cubes.

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

Syntax

The function has this syntax:

=INFOR.GET.CUBES({"spillByColumns", "data_connection", ["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	An optional parameter that represents the unique name of the data connection or a cell reference. If it is omitted, cubes from all data connections are retrieved.
`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: caption Returns the display name of the data connection. unique_name Returns the unique name of the data connection and can be used in formulas. description Returns the description of the cube. measure_dimension Returns the id of the measure dimension cube. time_dimension Returns the id of the time dimension cube. parent Returns the unique name of the data connection that contains the cube. MDSCHEMA_CUBES rowset

Return values

This function returns specified schema properties for all available cubes for the selected data connection. If the data connection is not provided, it returns all cubes.