XML Elements - Methods - Execute
Sends XML for Analysis (XMLA) commands to an instance of 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"
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>
Tilbakemeldinger
https://aka.ms/ContentUserFeedback.
Kommer snart: Gjennom 2024 faser vi ut GitHub Issues som tilbakemeldingsmekanisme for innhold, og erstatter det med et nytt system for tilbakemeldinger. Hvis du vil ha mer informasjon, kan du se:Send inn og vis tilbakemelding for