SI.DIMENSIONS

Overview

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

CODE

=SI.DIMENSIONS(ConnectionName, DimensionName, DimensionValue, [DimensionName], [DimensionValue]... [DimensionName], [DimensionValue])

Arguments

The SI. DIMENSIONS function uses the following arguments:

Argument	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

Examples

Example 1 - single dimension

Here is an example of the SI.DIMENSIONS function being used to provide the Dimensions argument to the SI.TURNOVER function:

CODE

=SI.TURNOVER("Sage",,"10010","2019-12-01","2019-12-31","*", SI.DIMENSIONS("Sage","Department","200")

In this case, the SI.DIMENSIONS function is creating the necessary matrix composed of the Department dimension and the value to be used (200)

Example 2 - multiple different dimensions

Here is an example of the SI.DIMENSIONS function being used to provide the PROJECT and TASK dimensions to the SI.CLOSINGBALANCE function:

Example 3 - multiple values for a single dimension

Here is an example of the SI.DIMENSIONS function being used to provide multiple values for the Department dimension to the SI.CLOSINGBALANCE function:

Example 4 - cell references for both dimensions and values

Here is an example of the SI.DIMENSIONS function being used to provide the Dimensions argument 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.

As described in , 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)