Using Aggregations to Performance Optimize a Cube - Getting Started with SQL Server 2012 Cube Development - page 247

5. Open up SQL Server Management Studio and connect to the Analysis Ser-
vices instance that contains the FirstCube database.
6. Click on the Analysis Services XMLA Query button.
7. Run the following XMLA query to clear the cache from the cube:
--Query 8.1
<ClearCache
xmlns="http://schemas.microsoft.com/
analysisservices/2003/engine">
<Object>
<DatabaseID>FirstCube</DatabaseID>
</Object>
</ClearCache>
8. Click on the Analysis Services MDX Query button to create a new MDX
query window. Run the following MDX query:
--Query 8.2
select {[Order
Date].[Hierarchy].[Calendar
Year].&[2005],[Order
Date].[Hierarchy].[Calendar Year].&[2006],
[Order Date].[Hierarchy].[Calendar
Year].&[2007],[Order
Date].[Hierarchy].[Calendar
Year].&[2008]} on rows,
[Product].[Product Hierarchy].[Product
Category] on columns
from [Adventure Works DW2012]
where
[Measures].[Sales Amount]