elstar.com.au

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.