EXTRACTPROPERTIES
With EXTRACTPROPERTIES you specify filters to extract specific properties from XML variables. The properties are extracted as XML. You can, for example, use an action to extract properties from one XML variable and write them to a second XML variable. Each filter consists of a key, property name and property value. In EXTRACTPROPERTIES, you specify the filter in the function. If you use EXRACTPROPERTIESBYFILTER, you can specify the filter with a separate function.
You can specify multiple filters and use the asterisk (*) wildcard to minimize the length of the syntax.
Syntax
EXTRACTPROPERTIES("XML_properties","key","property","value"
{,"key","property","value"})
Example
If a global variable, gv_property, holds the unique name and caption of an element in the Product dimension, this function returns the unique name:
=EXTRACTPROPERTIES(globalvariables.gv_property.text, "[Product]", "[unique]",
"[Product].[all tires].[car tires all season]")
Example
This example extracts both the unique name and the caption from gv_property:
=EXTRACTPROPERTIES(GlobalVariables.gv_property.Text,"[product]","unique","[product].[all
tires].[car tires all season]","[product]","caption","car tires all
season")
Example
This example also extracts the unique name and the caption from gv_property but uses wildcards:
=EXTRACTPROPERTIES(GlobalVariables.gv_setproperty.Text,"*","unique","*","caption","*")