TechNet
Export (0) Print
Expand All

Execute Method (XMLA)

 

Applies To: SQL Server 2016 Preview

Sends XML for Analysis (XMLA) commands to an instance of Microsoft SQL Server Analysis Services. This includes requests involving data transfer, such as retrieving or updating data on the server.

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

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

  
<Execute>  
   <Command>...</Command>  
   <Properties>...</Properties>  
   <Parameters>...</Parameters>  
</Execute>  

CharacteristicDescription
Data type and lengthNone
Default valueNone
Cardinality0-1: Optional element that occurs once and only once.
RelationshipElement
Parent elementNone
Child elementsCommand, Parameters, Properties

The Execute method executes XMLA commands provided in the Command element and returns any resulting data using either the XMLA Rowset data type (for tabular result sets) or the XMLA MDDataSet data type (for multidimensional result sets.)

The following code sample is an example of an Execute method call that contains an Multidimensional Expressions (MDX) SELECT statement.

<Execute xmlns="urn:schemas-microsoft-com:xml-analysis">  
   <Command>  
      <Statement>  
         SELECT [Measures].MEMBERS ON COLUMNS FROM [Adventure Works]  
      </Statement>  
   </Command>  
   <Properties>  
      <PropertyList>  
         <DataSourceInfo>Provider=MSOLAP;Data Source=local;</DataSourceInfo>  
         <Catalog>Adventure Works DW Multidimensional 2012</Catalog>  
         <Format>Multidimensional</Format>  
         <AxisFormat>ClusterFormat</AxisFormat>  
      </PropertyList>  
   </Properties>  
</Execute>  

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

Community Additions

ADD
Show:
© 2016 Microsoft