Applies to
⚠️ Velixo NX only
ERP: Sage Intacct
This function applies to Sage Intacct connections only.
Description
The SI.DIMENSIONS converts a sequence of pairs (DimensionName, DimensionValue) into the matrix format that is usable by certain Velixo functions for Sage Intacct.
Syntax
SI.DIMENSIONS(ConnectionName, DimensionName, DimensionValue, [DimensionName], [DimensionValue]... [DimensionName], [DimensionValue])
The SI. DIMENSIONS function uses the following parameters:
| Required/Optional | Description |
ConnectionName | Required | The name of the connection, as specified in the Connection Manager |
DimensionName | Required | The name of the Dimension being used. |
DimensionValue | Required | The value being applied to the DimensionName |
DimensionName | Optional | The next Dimension being used |
DimensionValue | Optional | The value being applied to the next DimensionName |
... | ... |
|
DimensionName | Optional | The last Dimension being used. |
DimensionValue | Optional | The value being applied to the last DimensionName |
Example
Here is an example of the SI.DIMENSIONS function being used to provide the Dimensions parameter to the SI.BUDGETTURNOVER function:
In this case, the SI.DIMENSIONS function is creating the necessary matrix composed of the Project and Task dimensions and the values to be applied to each.