SI.DIMENSIONS
Created by Damien Zwillinger, Modified on Thu, 05 Oct 2023 at 05:49 PM by Gabriel Michaud
Applies to:
- Velixo NX
- Sage Intacct
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.
Note: As described in Using Dimensions and starting from Velixo NX 2023.8, it is possible to also reference a N:N matrix with a similar same Name and Value structure. Considering the above example, SI.DIMENSIONS(J2,K2,J4,K4) can be replaced by a simple reference to J2:K3 (after removing the bank row between the two filled rows)
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article