Page 1 of 1

MDX Axis numbers must be sequentially specified

PostPosted: Tue Dec 02, 2008 6:16 am
by stephen
MDX query
This MDX query
select [Internet Sales].members on rows from [Analysis Services Tutorial]


gives this error
Axis numbers specified in a query must be sequentially specified, and cannot contain gaps
"

Solution
change rows to columns
eg
select [Internet Sales].members on columns from [Analysis Services Tutorial]


Axis Name
0 Columns
1 Rows
2 Pages
3 Chapters
4 Sections

Note from book MDX Solutions, Wiley
A query that uses axis 1 must also use axis 0, a query that uses axis 2 must also use axes 1 and 0. You cannot skip an axis in a query.