XML variables

Multiple values (for example, the captions and unique names of elements) can be saved in a single global variable. The definition of the variable and its properties is saved as XML. The XML is generated and maintained by using the SETPROPERTY (SETPROPERTY) function in conjunction with an action (for example, a Set parameters action) (Actions).

An XML variable can be used, for example, to hold the values of the slice dimensions in a report. By linking the XML variable to a Tuple report parameter the slice dimensions can be used for widget communication if the report is displayed in a dashboard.

See report parameter.

In the Accessories pane you can open a global variable for which properties have been created and see the XML definition.

See Accessories pane

For example, this SETPROPERTY function:

=SETPROPERTY(GlobalVariables.gvSetProperty,"[Product]","Unique",
"[Product].[All	Tires].[Car Tires All Season]")
	 
creates this XML statement in the gvSetProperty variable:
<Table><Row name="[product]"><Property name="unique" 
value="[Product].[All Tires].[Car Tires All Season]"/></Row></Table>
In this example, the Product dimension is the 'key' and is used as the row name. The name of the property is "Unique" and the value is the unique name of the All Season Tires element.

You can use SETPROPERTY to set multiple properties, values, and keys.