xml-elements-methods-execute.md

title	Execute Method (XMLA) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	analysis-services docset-sql-devref
ms.tgt_pltfrm
ms.topic	reference
apiname	Execute Method
apilocation	http://schemas.microsoft.com/analysisservices/2003/engine
apitype	Schema
applies_to	SQL Server 2016 Preview
f1_keywords	EXECUTE urn:schemas-microsoft-com:xml-analysis# http://schemas.microsoft.com/analysisservices/2003/engine# microsoft.xml.analysis.execute urn:schemas-microsoft-com:xml-analysis#Execute
helpviewer_keywords	Execute method
ms.assetid	0fff5221-7164-4bbc-ab58-49cf04c52664
caps.latest.revision	34
author	Minewiskan
ms.author	owend
manager	erikre

XML Elements - Methods - Execute

Sends XML for Analysis (XMLA) commands to an instance of [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion]. 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"

Syntax

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

Element Characteristics

Characteristic	Description
Data type and length	None
Default value	None
Cardinality	0-1: Optional element that occurs once and only once.

Element Relationships

Relationship	Element
Parent element	None
Child elements	Command, Parameters, Properties

Remarks

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.)

Example

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>  

See Also

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