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

9. Switch to the SQL Server Profiler window and review the trace. You will find
that the Get Data From Aggregation event has been raised.
Theprofilerwindowshowsthattheaggregationsareusedwhenrunningtheprevious
query. However the aggregations created cannot be used for all queries. It will be
used for queries that reference the level to which the aggregation was created for or
levels above that. As an example consider the following query:
--Query 8.3
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
Subcategory] on columns
from [Adventure Works DW2012]