Custom functions in preview
The functionality and syntax of these functions may change. Therefore, we recommend
that you use them only for experimental purposes.
This table shows the list of preview functions, their syntax, their results, and whether the functions support dynamic arrays:
| 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 | =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 | =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 | =READ.SLICE("reportDefinition"{, 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. | Yes |