Follow

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">
...
</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
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

2 Comments

  • 0
    Avatar
    Guðmundur Claxton

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

  • 0
    Avatar
    TVG Tom Vergote

    Same here

Please sign in to leave a comment.