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,",")