We have a new community! Please visit support.timextender.com

How to script aggregations on cubes in TimeXtender

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">
<Alter ObjectExpansion="ExpandFull" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
6. Add the script from step 5 as a post deployment step on the cube
Was this article helpful?
0 out of 0 found this helpful


  • 0
    Permanently deleted user

    In Version TX2012 I cannot paste the whole script inside the custom step window.  Is there a limit on the string length?

  • 0
    TVG Tom Vergote

    Same here

Please sign in to leave a comment.