SI.UDDVALUEID | Velixo

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

=SI.UDDVALUEID(
    ConnectionName, 
    DimensionName, 
    DimensionValue
)

Arguments

The SI.UDDVALUEID function uses the following arguments:

Argument	Required/ Optional	Description
`ConnectionName`	Optional	Provide one of the following values: Connection name as defined in Connection Manager. Velixo range expression defining a set of connection names. An array of settings as described in the Multiple connections per formula article. We recommend using the VX.SETTINGS function to construct the array. OR Omit the argument to return results for all compatible connections with default aggregation settings.
`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.

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/NDY5Zcc2MXwyQeyAEO_txREZ7TBX6NJcVQ.png

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

https://s3.ca-central-1.amazonaws.com/cdn.velixo.com/helpdesk/nJCnnDVGDOl_4svl2jJ3CLMHBI1rswL_6Q.png

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