PropertyList Element (XMLA)
Contains a collection of XML for Analysis (XMLA) properties used by the Discover and Execute methods.
Syntax
<Properties>
<PropertyList>
<!-- Zero or more XMLA properties -->
</PropertyList>
</Properties>
Element Characteristics
| Characteristic | Description |
|---|---|
Data type and length |
None |
Default value |
None |
Cardinality |
0-1: Optional element that can occur once and only once. |
Element Relationships
| Relationship | Element |
|---|---|
Parent elements |
|
Child elements |
XMLA properties (see Remarks) |
Remarks
The PropertyList element contains a collection of XMLA properties. Each property allows the user to control some aspect of the Discover or Execute method, such as defining the information required to connect to the data source, specifying the return format of the result set, or specifying the locale in which the data should be formatted. Each XMLA property in the PropertyList element is defined by a separate XML element. The value of the XMLA property is the data contained by the XML element, and the name of the XMLA property corresponds to the name of the XML element.
The available properties and their values can be obtained by using the DISCOVER_PROPERTIES request type with the Discover method. There is no required order for the properties listed in the PropertyList element.
For more information regarding the XMLA properties supported by Microsoft SQL Server 2005 Analysis Services (SSAS), see Supported XMLA Properties (XMLA).
Example
<Properties>
<PropertyList>
<DataSourceInfo>
Provider=MSOLAP;Data Source=local;
</DataSourceInfo>
<Catalog>
Foodmart 2000
</Catalog>
<Format>
Multidimensional
</Format>
</PropertyList>
</Properties>