Drillthrough MDX ERROR(Error.Number:-21467259) ?(urgent question)

In Excel 2003, I designed Macro which drill through Cubes by VBA. Now I
happened a problem that MDX Statment can't include more one member on each
axis. e.g.:
SELECT [Warehouse].[All Warehouses].[Canada].[BC] ON ROWS,
[Time].[1998].[Q1] ON COLUMNS,
[Time].[1997].[Q1] ON COLUMNS,/*error raises*/
[Product].[All Products].[Drink] ON PAGES,
[Measures].[Units Shipped] ON SECTIONS
FROM [My Cube]
if there have two members on columns axis, an error will be raised. But
there is the page area in PivotTable, End-User can set
"EnableMultiplePageItems " is TURE to select MULTIPLE ITEMS. it makes for
Error.Number:-21467259 and its description: Axis name is unrecognized or
duplicated ,or it creates a sequence gap,'1'.
Any one knows how to deal with it and have some good ways. thank for any
help or suggestions!


--
Developer
QA Dashboard
Microsoft China Development Centre

> Axis name is unrecognized or

> duplicated

As far as I know in MDX

You should not repeat one axis twice

NOT

[Time].[1998].[Q1] ON COLUMNS,

[Time].[1997].[Q1] ON COLUMNS,

BUT

Instead {[Time].[1998].[Q1],[Time].[1997].[Q1]} ON COLUMNS

It is called tuple and is put in {}

You should look up smth in news microsoft.public.sqlserver.olap on MDX
expressions

"Microlong" <[email protected]> wrote in message
news:[email protected]...
> In Excel 2003, I designed Macro which drill through Cubes by VBA. Now I
> happened a problem that MDX Statment can't include more one member on each
> axis. e.g.:
> SELECT [Warehouse].[All Warehouses].[Canada].[BC] ON ROWS,
> [Time].[1998].[Q1] ON COLUMNS,
> [Time].[1997].[Q1] ON COLUMNS,/*error raises*/
> [Product].[All Products].[Drink] ON PAGES,
> [Measures].[Units Shipped] ON SECTIONS
> FROM [My Cube]
> if there have two members on columns axis, an error will be raised. But
> there is the page area in PivotTable, End-User can set
> "EnableMultiplePageItems " is TURE to select MULTIPLE ITEMS. it makes for
> Error.Number:-21467259 and its description: Axis name is unrecognized or
> duplicated ,or it creates a sequence gap,'1'.
> Any one knows how to deal with it and have some good ways. thank for any
> help or suggestions!
>
>
> --
> Developer
> QA Dashboard
> Microsoft China Development Centre

thank for Yuri:
I research some information about OLAP SERVICE 2000, I found drillthrough
doesn't support more tuples in one MDX. e.g.:
SELECT [Warehouse].[All Warehouses].[Canada].[BC] ON ROWS,
>> {[Time].[1998].[Q1],[Time].[1997].[Q1]} ON COLUMNS
> > [Product].[All Products].[Drink] ON PAGES,
> > [Measures].[Units Shipped] ON SECTIONS
> > FROM [My Cube]
drillthrugh doesn't support above MDX statement even if its expression is
right .
thanks for your help!
"Yuri" wrote:

> > Axis name is unrecognized or
>
> > duplicated
>
> As far as I know in MDX
>
> You should not repeat one axis twice
>
> NOT
>
> [Time].[1998].[Q1] ON COLUMNS,
>
> [Time].[1997].[Q1] ON COLUMNS,
>
> BUT
>
> Instead {[Time].[1998].[Q1],[Time].[1997].[Q1]} ON COLUMNS
>
> It is called tuple and is put in {}
>
> You should look up smth in news microsoft.public.sqlserver.olap on MDX
> expressions
>
> "Microlong" <[email protected]> wrote in message
> news:[email protected]...
> > In Excel 2003, I designed Macro which drill through Cubes by VBA. Now I
> > happened a problem that MDX Statment can't include more one member on each
> > axis. e.g.:
> > SELECT [Warehouse].[All Warehouses].[Canada].[BC] ON ROWS,
> > [Time].[1998].[Q1] ON COLUMNS,
> > [Time].[1997].[Q1] ON COLUMNS,/*error raises*/
> > [Product].[All Products].[Drink] ON PAGES,
> > [Measures].[Units Shipped] ON SECTIONS
> > FROM [My Cube]
> > if there have two members on columns axis, an error will be raised. But
> > there is the page area in PivotTable, End-User can set
> > "EnableMultiplePageItems " is TURE to select MULTIPLE ITEMS. it makes for
> > Error.Number:-21467259 and its description: Axis name is unrecognized or
> > duplicated ,or it creates a sequence gap,'1'.
> > Any one knows how to deal with it and have some good ways. thank for any
> > help or suggestions!
> >
> >
> > --
> > Developer
> > QA Dashboard
> > Microsoft China Development Centre
>
>
>