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("Database Alias", "Cube", "MLS-XML definition","separator").The MLS-XML definition might be stored in a cell, or in a variable.

Example

=MULTISELECTGETMEMBERS("Best Practices OLAP","Analysis",E37,",")

Related topics