Custom functions in preview

Formula	Syntax	Result	Dynamic array support
INFOR.JOINARRAYS	`INFOR.JOINARRAYS(use_crossjoin, first_array, second_array {, [array], ...})`	Returns an array of values of any type, joined by columns.	Yes
INFOR.SUBARRAY	`INFOR.SUBARRAY([array] {,first_column, column_count, first_row, row_count})`	Returns an array of values of any type. It represents sub array of a selected array.	Yes
INFOR.READ.SESE.REPORT	`INFOR.READ.SESE.REPORT([report_parameters], ...)`	Returns a report that is generated based on the JSON definition of the Self-Service report.	Yes
INFOR.GET.ELEMENT.ATTRIBUTE	`INFOR.GET.ELEMENT.ATTRIBUTE("data_connection", "cube", "attribute", "hierarchy", "element"{, ["context"], ...})`	Returns a single attribute for a given element or multiple elements with a given context if the attribute is dynamic and is driven by other dimensions.	No
INFOR.WRITE.ELEMENT.ATTRIBUTE	`INFOR.WRITE.ELEMENT.ATTRIBUTE("value", "data_connection", "cube", "attribute", "hierarchy", "element"{, ["context"], ...})`	Returns an attribute value if successful or an error in case of failure. It writes a value to a single attribute for a single element with a given context if the attribute is dynamic and is driven by other dimensions.	No
INFOR.GET.AXIS	`INFOR.GET.AXIS("data_connection", "cube", spillByColumns, options, {, "hierarchy", [attributes], [elements], [options], [filters]},...)`	Returns a matrix of requested attributes for given hierarchies. It renders a whole axis of columns or rows. That is, if a user asks for various elements and attributes from multiple hierarchies, a cross join is created.	Yes
INFOR.READ.VALUES	`INFOR.GET.VALUES("data_connection", "cube" {, "cell_property", [rows_element], [row_index_offset], [columns_element], [column_index_offset], [slice_element] ... })`	Retrieves a matrix of values for given axes and filter elements. It is useful for maintaining performance when reading multiple values from a cube.	Yes
INFOR.READ.SLICE	`INFOR.READ.SLICE("reportDefinition"{[options], [parametrizationArgument] ... })`	Used in ad-hoc reports. If used with the Excel Integration user interface, it enables interactions with a sheet, such as expanding and collapsing of axis elements. Helpful for an ad-hoc analysis. With the `options` argument you can define filters direction, switch from expandable slice to non-expandable slice, define the number format. You can enable the dynamic styles by setting `UseStyles` to true in the `options` argument.	Yes
INFOR.ELEMENT.ENTITY	`INFOR.ELEMENT.ENTITY ("data_connection", "cube", [attributes], "hierarchy", [element] {, [context], ...})`	It is an entity variant of the `INFOR.GET.ELEMENT`. Returns a single element entity. Retrieves multiple member properties to a single cell. You can reference this formula without introducing the element unique name.	No
INFOR.VALUE.ENTITY	`INFOR.VALUE.ENTITY ("data_connection", "cube" {, [cell_property], "number_format", cell_coordinate, ... })`	It is an entity variant of the `INFOR.READ.VALUE`. Returns multiple cell properties to a single cell.	No
INFOR.SLICE.ENTITY	`INFOR.SLICE.ENTITY("reportDefinition"{[options], [parametrizationArgument] ... })`	It is an entity variant of the `INFOR.READ.SLICE` where `parametrizationArgument` is any number of matrix arguments. You can define options with these arguments. Returns dynamic array of custom data types. Supports interactive behavior. Enables actions like Move To, Keep, Zoom In/Out. With the `options` argument you can define filters direction, switch from expandable slice to non-expandable slice, define the number format. You can enable the dynamic styles by setting `UseStyles` to true in the `options` argument.	Yes

INFOR.JOINARRAYS

INFOR.JOINARRAYS(use_crossjoin,
                first_array, second_array {, [array], ...})

Returns an array of values of any type, joined by columns.

Yes

INFOR.SUBARRAY

INFOR.SUBARRAY([array] {,first_column,
                column_count, first_row, row_count})

Returns an array of values of any type. It represents sub array of a selected array.

Yes

INFOR.READ.SESE.REPORT

INFOR.READ.SESE.REPORT([report_parameters],
              ...)

Returns a report that is generated based on the JSON definition of the Self-Service report.

Yes

INFOR.GET.ELEMENT.ATTRIBUTE

INFOR.GET.ELEMENT.ATTRIBUTE("data_connection", "cube",
                "attribute", "hierarchy", "element"{, ["context"], ...})

Returns a single attribute for a given element or multiple elements with a given context if the attribute is dynamic and is driven by other dimensions.

No

INFOR.WRITE.ELEMENT.ATTRIBUTE

INFOR.WRITE.ELEMENT.ATTRIBUTE("value", "data_connection",
                "cube", "attribute", "hierarchy", "element"{, ["context"], ...})

Returns an attribute value if successful or an error in case of failure. It writes a value to a single attribute for a single element with a given context if the attribute is dynamic and is driven by other dimensions.

No

INFOR.GET.AXIS

INFOR.GET.AXIS("data_connection", "cube", spillByColumns,
                options, {, "hierarchy", [attributes], [elements], [options],
                [filters]},...)

Returns a matrix of requested attributes for given hierarchies. It renders a whole axis of columns or rows. That is, if a user asks for various elements and attributes from multiple hierarchies, a cross join is created.

Yes

INFOR.READ.VALUES

INFOR.GET.VALUES("data_connection", "cube" {,
                "cell_property", [rows_element], [row_index_offset], [columns_element],
                [column_index_offset], [slice_element] ... })

Retrieves a matrix of values for given axes and filter elements. It is useful for maintaining performance when reading multiple values from a cube.

Yes

INFOR.READ.SLICE

INFOR.READ.SLICE("reportDefinition"{[options],
                [parametrizationArgument] ... })

Used in ad-hoc reports. If used with the Excel Integration user interface, it enables interactions with a sheet, such as expanding and collapsing of axis elements. Helpful for an ad-hoc analysis. With the options argument you can define filters direction, switch from expandable slice to non-expandable slice, define the number format. You can enable the dynamic styles by setting UseStyles to true in the options argument.

Yes

INFOR.ELEMENT.ENTITY

INFOR.ELEMENT.ENTITY ("data_connection", "cube",
                [attributes], "hierarchy", [element] {, [context], ...})

It is an entity variant of the INFOR.GET.ELEMENT. Returns a single element entity. Retrieves multiple member properties to a single cell. You can reference this formula without introducing the element unique name.

No

INFOR.VALUE.ENTITY

INFOR.VALUE.ENTITY ("data_connection", "cube" {,
                [cell_property], "number_format", cell_coordinate, ... })

It is an entity variant of the INFOR.READ.VALUE. Returns multiple cell properties to a single cell.

No

INFOR.SLICE.ENTITY

INFOR.SLICE.ENTITY("reportDefinition"{[options],
                [parametrizationArgument] ... })

It is an entity variant of the INFOR.READ.SLICE where parametrizationArgument is any number of matrix arguments. You can define options with these arguments. Returns dynamic array of custom data types. Supports interactive behavior. Enables actions like Move To, Keep, Zoom In/Out. With the options argument you can define filters direction, switch from expandable slice to non-expandable slice, define the number format. You can enable the dynamic styles by setting UseStyles to true in the options argument.

Yes