Using XML functions and variables in server lists

XML variables store multiple values in a single variable.

These XML functions extract values from XML variables:

  • GETKEY
  • GETKEYS
  • GETKEYVALUES
  • GETPROPERTIES
  • GETPROPERTY
  • 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.