XML for Analysis - Microsoft SQL Server 2008 Analysis Services - page 588

</AxisInfo>

In addition to the axes defined by the MDX Select statement, the server returns one
more axis, SlicerAxis :

<AxisInfo name=”SlicerAxis”>
...
</AxisInfo>
</AxesInfo>

The CellInfo section contains information about cell properties:

<CellInfo>
<Value name=”VALUE”/>
<FmtValue name=”FORMATTED_VALUE” type=”xsd:string”/>
<CellOrdinal name=”CELL_ORDINAL” type=”xsd:unsignedInt”/>
</CellInfo>
</OlapInfo>

The Axes Section After the application receives the data about the structure of the
result, it can start reading the result itself. The Axes section contains a list of all the axes,
in the same order as they were specified in the MDX statement, followed by SlicerAxis .
The XML/A specification defines three possible formats for the serialization of an axis:

. ClusterFormat

. TupleFormat

. CustomFormat

Because Analysis Services supports only TupleFormat , we limit the discussion to this format.

The response to our request, therefore, would look like this:

<Axes>
<Axis name=”Axis0”>

Each axis contains a list of tuples; each tuple contains one or more members:

<Tuples>
<Tuple>

The Hierarchy attribute of the Member element specifies the hierarchy the member belongs
to. It can have child elements for each member property.

<Member Hierarchy=”[Measures]”>
<UName>[Measures].[Unit Sales]</UName>
<Caption>Unit Sales</Caption>
<LName>[Measures].[MeasuresLevel]</LName>
<LNum>0</LNum>