MULTISELECTCREATE

MULTISELECTCREATE creates a valid multiselect XML (MLS-XML) definition. You use MULTISELECTADD to populate the definition with elements from a specified hierarchy.

Syntax

=MULTISELECTCREATE("hierarchy_unique_name","aggregation_function")

Valid aggregation functions are Sum, Avg, Min, Max, and Any.

Example

=MULTISELECTCREATE("[Period]","Sum")

Note: If you specify a MULTISELECTCREATE function in a cell, the cell displays </MultiSelect>. Expand the height of the cell to display the full MLS-XML definition.

Use MULTISELECTCREATE in, for example, a Set Parameters action to populate a variable with the MLS-XML definition.

Use MULTISELECTADD to add hierarchy elements to an MLS-XML definition.