Properties Element (XMLA)


Applies To: SQL Server 2016 Preview

Contains XML for Analysis (XMAL) properties used by the Discover and Execute methods.

<Discover> <!-- or Execute -->  

Data type and lengthNone
Default valueNone
Cardinality1-1: Required element that occurs once and only once.
Parent elementsDiscover, Execute
Child elementsPropertyList

The Properties element represents XMLA properties used to control aspects of the Discover and Execute methods, 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.

The available properties and their values can be obtained by using the DISCOVER_PROPERTIES request type with the Discover method.

         Provider=MSOLAP;Data Source=local;  
         Foodmart 2000  

Properties (XMLA)

Community Additions