Querying Your Cube - Getting Started with SQL Server 2012 Cube Development - page 119

Youcanalsoreferenceanaxisnumberinsteadofthealiases.Ifyoudothatthequery
would look like the following:
--Query 5.5
SELECT [Order Date].[Hierarchy].[Calendar Year]
ON 0,
[Product].[Product Hierarchy].[Product
Category] ON 1
FROM [Adventure Works DW2012]
WHERE [Measures].[Fact Internet Sales Count];
Note
Even though that Analysis Services can handle more than two axes in a query
set, not all tools can handle a result set of this type. If you try to execute the fol-
lowing query:
--Query 5.6
SELECT [Order Date].[Hierarchy].[Calendar
Year] ON 0,
[Product].[Product Hierarchy].[Product
Category] ON 1,
[Sales Territory].[Sales Territory
Group].[Sales Territory Group] ON 2
FROM [Adventure Works DW2012]
WHERE [Measures].[Fact Internet Sales
Count];
If you try to execute it in Management Studio, you will get the following result:
Executing the query ...
Obtained object of type:
Microsoft.AnalysisServices.AdomdClient.CellSet
Formatting.
Results cannot be displayed for cellsets