Discover Method (XMLA)

 

Updated: September 14, 2016

Applies To: SQL Server 2016 Preview

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>  

CharacteristicDescription
Data type and lengthNone
Default valueNone
Cardinality0-1: Optional element that can occur once and only once.
RelationshipElement
Parent elementNone
Child elementsProperties, RequestType, Restrictions

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

System_CAPS_ICON_tip.jpg Tip

If you are unfamiliar with XML commands, click the XMLA query template on the Query toolbar in Management Studio, to build the query and add parameters. For more information, see Use Analysis Services Templates in SQL Server Management Studio.

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

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

XML Data Types (XMLA)
Execute Method (XMLA)
Methods (XMLA)
XML Elements (XMLA)
Analysis Services Schema Rowsets

Community Additions

ADD
Show: