VX.SETTINGS

Overview

The function creates a 2D Excel array you can use as the Dimensions or Settings argument in various Velixo NX functions.

CODE

=VX.SETTINGS(
  SettingNameOrValue,
  SettingNameOrValue,
  SettingNameOrValue,
  SettingNameOrValue,
  ...
)

Argument	Required / Optional	Description
`SettingNameOrValue`	Required	First key name (setting/dimension/parameter).
`SettingNameOrValue`	Required	A value corresponding to the key.
…
`SettingNameOrValue`	Optional	Final key name(setting/dimension/parameter).
`SettingNameOrValue`	Optional	An additional value corresponding to the final key. If the N-th parameter name is provided, the N-th value is required.

CODE

=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.