Partilhar via

Discover Method (XMLA)

  • Artigo

Retrieves information, such as the list of available databases or details about a specific object, from an instance of Microsoft SQL Server 2005 Analysis Services (SSAS). 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

<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>
         <Catalog>Adventure Works DW</Catalog>
         <Format>Tabular</Format>
      </PropertyList>
   </Properties>
</Discover>

See Also

Reference

Execute Method (XMLA)
XML Elements (XMLA)

Other Resources

XML Data Types (XMLA)
Methods (XMLA)
Schema Rowsets

Help and Information

Getting SQL Server 2005 Assistance