This topic has not yet been rated - Rate this topic

Discover Method (XMLA)

SQL Server 2008 R2

Retrieves information, such as the list of available databases or details about a specific object, from an instance of Microsoft SQL Server Analysis Services. The data retrieved with the Discover method depends on the values of the parameters passed to it.

Namespace urn:schemas-microsoft-com:xml-analysis

SOAP Action "urn:schemas-microsoft-com:xml-analysis:Discover"

Syntax

Xml


<Discover>
   <RequestType>...</RequestType>
   <Restrictions>...</Restrictions>
   <Properties>...</Properties>
</Discover>

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 element	None
Child elements	Properties, RequestType, Restrictions

Remarks

The Discover method requests metadata about Analysis Services instances and objects. Metadata is returned using the XMLA Rowset data type.

Example

In the following code sample, the client sends the Discover call to request a list of cubes from the Adventure Works DW sample Analysis Services database:

<Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
   <RequestType>MDSCHEMA_CUBES</RequestType>
   <Restrictions>
      <RestrictionList>
         <CATALOG_NAME>Adventure Works DW</CATALOG_NAME>
      </RestrictionList>
   </Restrictions>
   <Properties>
      <PropertyList>
         <DataSourceInfo>Provider=MSOLAP;Data Source=local;</DataSourceInfo>
         <Catalog>Adventure Works DW</Catalog>
         <Format>Tabular</Format>
      </PropertyList>
   </Properties>
</Discover>

Reference

Execute Method (XMLA)

XML Elements (XMLA)

Schema Rowsets

Other Resources

XML Data Types (XMLA)

Methods (XMLA)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD