With your deployed- and processed cube, do the following:
Using BIDS
1. Add aggregations to your cube using the Aggregation Design Wizard
2. Save the cube incl. all affected objects onto the server
Using Management Studio
3. Script the aggregation design as Create
4. Script the partition as Alter
Using TimeXtender
5. Create a custom action “Aggregations and partition”
a. Add the scripts from step 3 and 4 in a batch statement as the following example
<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"><Create xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">...</Create><Alter ObjectExpansion="ExpandFull" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">...</Alter></Batch>
6. Add the script from step 5 as a post deployment step on the cube
2 Comments