Overview
The function creates a 2D Excel array you can use as the Dimensions or Settings argument in various Velixo NX functions.
Syntax
=VX.SETTINGS(
SettingNameOrValue,
SettingNameOrValue,
SettingNameOrValue,
SettingNameOrValue,
...
)
Arguments
|
Argument |
Required /
|
Description |
|---|---|---|
|
|
Required |
First key name (setting/dimension/parameter). |
|
|
Required |
A value corresponding to the key. |
|
… |
|
|
|
|
Optional |
Final key name(setting/dimension/parameter). |
|
|
Optional |
An additional value corresponding to the final key. If the N-th parameter name is provided, the N-th value is required. |
In cases where empty arguments are provided, the VX.SETTINGS function:
-
excludes a key-value pair from the spilled output when both the key and the value are empty,
-
does not exclude a pair when the key is present but the value is empty,
-
returns an error when the key is empty, but the value is present in a pair.
Example
=VX.SETTINGS("Connection","Connection1, Connection2","AggregationMode","sum","GlobalAggregation","TRUE")
Description: The result is an array that is ready to use as the multi-connection ConnectionName argument in numerous Velixo functions.
