Поделиться через


Execute Method (XMLA)

Sends XML for Analysis (XMLA) commands to an instance of Microsoft SQL Server 2005 Analysis Services (SSAS). 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>

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

Замечания

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</Catalog>
         <Format>Multidimensional</Format>
         <AxisFormat>ClusterFormat</AxisFormat>
      </PropertyList>
   </Properties>
</Execute>

См. также

Справочник

Discover Method (XMLA)
XML Elements (XMLA)

Другие ресурсы

XML Data Types (XMLA)
Methods (XMLA)
Schema Rowsets

Справка и поддержка

Получение помощи по SQL Server 2005