SI.EXPANDUDDVALUERANGE

Applies to:

Velixo NX 2025.5 or higher
Sage Intacct

Overview

The SI.EXPANDUDDVALUERANGE function returns values from a Sage Intacct user-defined dimension (UDD).

These values can then be used in functions like SI.EXPANDGLHISTORY for UDD filtering.

Note: In case you want to use UDDs in SI.QUERY or SI.WRITEBACK… functions, you can easily retrieve UDD value IDs they require using the SI.UDDVALUEID function.

Syntax

=SI.EXPANDUDDVALUERANGE(ConnectionName, DimensionName, DimensionValue)

The SI.UDDVALUEID function uses the following parameters:

Parameter	Required/ Optional	Description
ConnectionName	Required	The name of the connection as configured in the Connection Manager
DimensionName	Required	The integration name of the user-defined dimension ID you want to expand
DimensionValue	Optional	The UDD value or range, as you see it in the Sage Intacct interface. This is a string for filtering user-defined dimension values. The DimensionValue string supports Velixo filtering techniques. The parameter is case-insensitive.

Output

The function returns an array containing all members of the specified user-defined dimension matching the DimensionValue parameter (if provided).

Example

=SI.EXPANDUDDVALUERANGE("Sage", "SITE")

This formula returns all values for the user-defined dimension named SITE.

Info: You can find the dimension values by navigating to your UDD in Sage Intacct.

You can apply Velixo filtering techniques to the DimensionValue parameter to narrow down results. For instance, the following formula returns all values but those whose names start with Location.

=SI.EXPANDUDDVALUERANGE("Sage", "SITE", "*;-Location?")