Using XML functions and variables in server lists

XML variables store multiple values in a single variable.

SeeXML variables.

There are six XML functions which extract values from XML variables. They are:

1. GETKEY

   See GETKEY

2. GETKEYS

   See GETKEYS

3. GETKEYVALUES

   See GETKEYVALUES

4. GETPROPERTIES

   See GETPROPERTIES

5. GETPROPERTY

   See GETPROPERTY

6. GETPROPERTYVALUES

   See GETPROPERTYVALUES

These are useful in dynamic reports where, for example, slice-dimensions and their elements are stored in an XML variable and you need to extract a comma-separated list of elements.

Formulas can contain text, object properties or a combination of both.

SeeWorking with Custom MDX and Edit Formula options.