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" wrote in message
...
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" wrote in message
...
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