ADLC Step 2: Remove Ineffective Aggregations

This is the second post in a series of posts covering the Aggregation Design Life-Cycle (ADLC).

In the previous post, we discussed the process for creating the initial set of aggregation designs which, from an aggregation perspective, serves as the jumping off point for a new cube prior to deployment into production. In that post we primarily focused on the Aggregation Design Wizard and ways in which we can influence the resulting aggregation designs to better match our expected query load. Now, in this post we'll be focusing on the second step in the ADLC which involves a bit of clean up that needs to take place before & after the cube is deployed to production.