MULTISELECTGETMEMBERS

MULTISELECTGETMEMBERS gets a list of elements from a valid multiselect XML (MLS-XML) definition, separated by, for example, commas. You can specify the list separator.

Syntax

=MULTISELECTGETMEMBERS("data_connection","cube","XML_multiselect","separator")

The MLS-XML definition might be stored in a cell, or in a variable.

Example

=MULTISELECTGETMEMBERS("BestPracticesOLAP","Analysis",E37,",")