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