I have a problem with
the cube deployment wizard.
I am working with SQL server 2008 R2.
I have created my Cube with BIDS, with a few partitions. Then I have a job which will add new partitions on a daily basis.
In BIDS, the Aggregation design is defined and assigned to the partitions.
I have 3 measure groups, each with 2 aggregations. Some partitions are assigned to the 'Day' aggregation, the other to the 'Month' aggregation design.
When I deploy with BIDS, all defined partitions are created with their 'Aggregation' assigned.
When I add new partitions with the job, the 'Day' aggregations are assigned to the new partitions. When I script the partitions with SSMS directly after the partitions are added, the 'AggregationDesignID' tag is in the script.
When I afterwards deploy some changes of my cube with the 'Deployment wizard', with 'Retain partitions' checked, then the aggregations are kept, but the assignment to ALL partitions is lost.
When I choose to create a deployment script, in the script I see all the existing partitions, with the 'estimated count' tag
View Complete Post