SlicerAxis in Execute response   

Hi,

I'm confused as to the purpose of the <Axes><Axis name="SlicerAxis">
in the Execute response.

If my MDX statement is:
SELECT
{
Measures.[Order Quantity], Measures.[Sales quantity]
}
ON COLUMNS,
NON EMPTY
{
Product.[Product Name].&[228]
}
ON ROWS
FROM [My Cube]
WHERE [Customer].[City].[Birmingham]

then my understanding is that [Customer.[City].[Binmingham] is my slicer 
axis. However, the response returns every possible tuple in SlicerAxis from 
the cube. This is confusing me. I thought that the contents of <Axes> 
relates directly to the returned <CellData>. If it should be anywhere, 
shouldn't it be in the <OlapInfo> rather than the <Axes>?

Ken

date: Thu, 23 Feb 2006 13:55:44 -0000   author:   Ken Campbell nospamkencat/edpdot/fastfreenetdot/com/nospam

Re: SlicerAxis in Execute response   

The slicer axis essentially contains the coordinates of the hierarchies that 
are not on the other axes (rows/columns/etc).

The OlapInfo section contains the AxisInfo which defines which hierarchies 
are in the slicer axis (and their order).

Subsequently the <Axis> element actually contains the tuple(s) that actually 
belong to the axis. In the case of the slicer axis, there will be exactly 
one tuple.

For the purpose of serialization, the slicer axis is treated almost like any 
other axis except that it has a special name...

HTH,
Akshai
--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Ken Campbell kenc edp fastfreenet com >" <<nospamat/dot/dot//nospam> wrote 
in message news:eazLZDIOGHA.532@TK2MSFTNGP15.phx.gbl...
> Hi,
>
> I'm confused as to the purpose of the <Axes><Axis name="SlicerAxis">
> in the Execute response.
>
> If my MDX statement is:
> SELECT
> {
> Measures.[Order Quantity], Measures.[Sales quantity]
> }
> ON COLUMNS,
> NON EMPTY
> {
> Product.[Product Name].&[228]
> }
> ON ROWS
> FROM [My Cube]
> WHERE [Customer].[City].[Birmingham]
>
> then my understanding is that [Customer.[City].[Binmingham] is my slicer 
> axis. However, the response returns every possible tuple in SlicerAxis 
> from the cube. This is confusing me. I thought that the contents of <Axes> 
> relates directly to the returned <CellData>. If it should be anywhere, 
> shouldn't it be in the <OlapInfo> rather than the <Axes>?
>
> Ken
>

date: Thu, 23 Feb 2006 14:57:32 -0800   author:   Akshai Mirchandani [MS]