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

15. As you can see the wizard has created aggregations for the Order Date di-
mension on the month level or a lower level. This is due to the full aggrega-
tion setting that was specified on the month attribute.
To test the aggregations, start a new profiler trace against the server by following the
given steps.
1. Start SQL Server Profiler and create a new trace.
2. Under the Events Selection , click on the checkbox called Show all events .
3. Add the event called Get Data From Aggregation that can be found under
the Query Processing section.
4. Click the Run button to start the profiler trace.