Properties Element (XMLA)

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

Syntax

<Discover> <!-- or Execute -->
...
   <Properties>
      <PropertyList>...</PropertyList>
   </Properties>
...
</Discover>

Element Characteristics

Characteristic	Description
Data type and length	None
Default value	None
Cardinality	1-1: Required element that occurs once and only once.

Element Relationships

Relationship	Element
Parent elements	Discover, Execute
Child elements	PropertyList

Remarks

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.

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