SI.DIMENSIONS

Created by Damien Zwillinger, Modified on Mon, 24 Jun at 7:08 PM by Harry Lewis

Applies to:

  • Velixo NX
  • Sage Intacct


TABLE OF CONTENTS



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:



Parameter

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 parameter to the SI.TURNOVER function:

=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 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, 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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article