BC.EXPANDDIMENSIONVALUERANGE

Overview

The BC.EXPANDDIMENSIONVALUERANGE function lets you retrieve value codes within a specified dimension in your Business Central instance.

CODE

=BC.EXPANDDIMENSIONVALUERANGE(
    ConnectionName, 
    Dimension,
    DimensionValueCode
)

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection, as specified in the Connection Manager
`Dimension`	Required	Dimension name.
`DimensionValueCode`	Optional	Dimension value code filter. You can specify the filter using Velixo filtering techniques.

CODE

=BC.EXPANDDIMENSIONVALUERANGE(
    "BC",
    "Area",
    "10:50"
)

Description:

Returns all value codes for the dimension Area with values ranging from 10 to 50, defined for the connection BC.