Creating Analysis Services Cubes - SQL Server Analysis Services 2012 Cube Development - page 118

How to do it...
To design aggregations using BIDS Helper, perform the following steps:
1. Click on a cube within SSDT and select Edit Aggregations to activate Ag-
gregation Manager .
2. As shown in the next screenshot, Aggregation Manager displays and allows
the editing of existing aggregation designs. You can also create new aggreg-
ation designs. For reference, have a look at the following screenshot:
3. Right-click on the existing design and select Edit . Within the dialog you will
see that you can check those attributes you wish to aggregate.
4. Alternatively, you could also copy a particular dataset from the query log table
and paste it into the Aggregation Definition column.
5. The tool also allows you to add aggregation definitions directly from the
Query Log. For example, you could specify the SQL statement to find only
those subcubes that took excessively long to retrieve, or those that were ex-
ecuted by a user who complained about slow queries.
6. You can also use Aggregation Manager to provide more descriptive names
for your aggregations instead of using the generic Aggregation 0 .
7. Once you're happy with your aggregation design, you can apply it to the ne-
cessary partitions, save your changes, and review the results in SSMS.