PropertyList Element (XMLA)


Applies To: SQL Server 2016 Preview

Contains a collection of XML for Analysis (XMLA) properties used by the Discover and Execute methods.

      <!-- Zero or more XMLA properties -->  

Data type and lengthNone
Default valueNone
Cardinality0-1: Optional element that can occur once and only once.
Parent elementsProperties
Child elementsXMLA properties (see 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 Analysis Services, see Supported XMLA Properties (XMLA).

         Provider=MSOLAP;Data Source=local;  
         Foodmart 2000  

Properties (XMLA)

Community Additions