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.