How To: Create a Copy of an Existing Aggregation Design
During the development and on going maintenance of a SSAS database, there are times when you'll want to have a backup copy of an existing aggregation design. The primary use case to consider is when you are creating customized aggregations (either manually or via the Usage-Based Optimization Wizard). By having a backup copy of the original aggregation design, you can safely merge in the new customized aggregations, test the results, and roll back if you don't get enough bang for the buck.
Read more...Tags: management, aggregation