MULTISELECTREMOVE

Removes elements from a multiselect XML (MLS-XML) definition.

MULTISELECTREMOVE is typically used as a parameter of a Set Parameters action.

Syntax

The function requires a valid MLS-XML definition, and pairs of arguments that specify the type and unique name of each element to add to remove from the definition.

Note: Currently, only the 'Member' element type is supported.

This is the syntax of the function:

=MULTISELECTREMOVE("MLS-XML","Element Type","Element_unique_name"...,"Element Type","Element_unique_name")

The Element_unique_name argument can be a cell reference or a reference to a variable which contains a unique name.

Note: MULTISELECTREMOVE does not validate element unique names. You must ensure that valid unique names are specified.

Example

Cell C6 contains this multiselect xml:

<?xml version="1.0" encoding="utf-16"?>
<MultiSelect xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <Hierarchy>[product]</Hierarchy>
  <AggregationFunction>Sum</AggregationFunction>
  <StructureSelection>
    <Member>
      <MemberUName>[product].[all tires].[car tires all season]</MemberUName>
    </Member>
    <Member>
      <MemberUName>[product].[all tires].[car tires summer]</MemberUName>
    </Member>
    <Member>
      <MemberUName>[product].[all tires].[car tires winter]</MemberUName>
    </Member>
  </StructureSelection>
</MultiSelect

This example creates the same xml but without the Car Tires Summer element:

=MULTISELECTREMOVE(C6,"member","[product].[all tires].[car tires summer]")

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