SI.EXPANDUDDVALUERANGE

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.

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

CODE

=SI.EXPANDUDDVALUERANGE(
    ConnectionName, 
    DimensionName, 
    DimensionValue
)

Arguments

The SI.UDDVALUEID function uses the following arguments:

Argument	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 argument is case-insensitive.

Output

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

Example

CODE

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

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

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

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

CODE

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