Deply aggregations

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Deply aggregations

Deply aggregations

Rate Topic

Display Mode

Topic Options

Author

Message

aarded

Posted Thursday, January 10, 2013 7:51 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 22, 2013 2:17 AM
Points: 35, Visits: 248

Hi,

I'm using SQL server 2008 R2.
Monthly a job creates new 'month' partitions. So this partitions are not in my BIDS project.

Now I have created some 'usage based aggregations', and want to deloy them.

My problem:
When I deploy them with 'Retain partitions' the new aggregations are not deployed
When I deploy them without 'Retain partitions' checked, my job-create partitions are gone.

What is the best way to deploy the Aggregations, without losing my partitions?

Thanks for any suggestions.

Post #1405464

aarded

Posted Wednesday, January 16, 2013 1:45 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, April 22, 2013 2:17 AM
Points: 35, Visits: 248

Solution from www.ssas-info.com:

When you have BIDS helper installed, it's possible to deploy the aggregations only. There is a button in the partitions tab.

However it's not possible to create a script to deploy only the aggregations.

grts,
Eric.

Post #1407674

« Prev Topic | Next Topic »

Permissions