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	Properties
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>

See Also

Concepts

Properties (XMLA)

Help and Information

Getting SQL Server 2005 Assistance