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
<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
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 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>
See Also
Reference
Other Resources