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:
|
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.