BC.EXPANDDIMENSIONRANGE

Overview

The BC.EXPANDDIMENSIONRANGE function lets you retrieve a list of dimensions defined in your Business Central instance.

=BC.EXPANDDIMENSIONRANGE(
    ConnectionName, 
    Dimension,
    IncludeBlocked
)

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.
`Dimension`	Optional	Filter for dimension names. You can specify the filter using Velixo filtering techniques.
`IncludeBlocked`	Optional	If `FALSE`, return only unblocked dimensions. Accepted values: `TRUE` and `FALSE` Default value: `TRUE`

=BC.EXPANDDIMENSIONRANGE(
    "BC"
)

Description:

Returns all dimensions defined for the connection BC.