Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Discover Method (XMLA)

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"


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

Characteristic

Description

Data type and length

None

Default value

None

Cardinality

0-1: Optional element that can occur once and only once.

Relationship

Element

Parent element

None

Child elements

Properties, RequestType, Restrictions

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

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>
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.