SI.UDDVALUEID

Overview

The SI.UDDVALUEID function returns the value ID for a user-defined dimension (UDD) - an argument used by the SI.QUERY or SI.WRITEBACK functions when working with UDDs.

You can find the UDD value in Sage Intacct as well, but the SI.UDDVALUEID function is much more convenient.

Syntax

CODE

=SI.UDDVALUEID(
    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 for which you want to retrieve IDs.
`DimensionValue`	Required	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 a spill range with UDD IDs, which you can use in SI.QUERY or SI.WRITEBACK functions.

Example

Say, you want to get IDs for the values of your UDD named SITE.

First, you can leverage the SI.EXPANDUDDVALUERANGE function to get all UDD values.

Then, get the UDD value IDs using SI.UDDVALUEID.

Using the “#” symbol (“A3#”) makes the function return values for cells A3 and below.