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

Adding aggregations manually
You can add aggregations manually either by creating an entirely new aggregation
design, or creating a new aggregation in an already created aggregation design.
To add a new aggregation to the already existing aggregation design, follow the given
steps:
1. Click the New Aggregation button in the Advanced View under Aggrega-
tions .
2. In the A0 column check the box in front of the [Order Date].[Month] ,
the [Order Date].[Hierarchy Order Date Calculations] , and the
[Product].[Product Subcategory] attributes.
3. Process and deploy the cube.
4. Start a SQL Server Profiler trace with the Get Data From Aggregation se-
lected.
5. Run the following code:
--Code 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]
where
[Measures].[Sales Amount]
6. Review the profiler trace, as you can see you can find a Get Data From Ag-
gregation event with the following TextData :
Aggregation 0
01111,00000,00000,0000000011,0000,000000,000,00000000,0