How do you service your Cubes if using dynamic partitioning

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » How do you service your Cubes if using...

How do you service your Cubes if using dynamic partitioning

Rate Topic

Display Mode

Topic Options

Author

Message

christian.terhart

Posted Tuesday, January 15, 2013 4:18 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 25, 2013 7:31 AM
Points: 83, Visits: 364

Hi there,

I am thinking about using partitioning as a tool to reduce our cube processing time.

While I was thinking about dynamicly adding new partitions over xmla I thought: What if I have to change something in the cube after a few month?

If I open the solution that I created for the cube, the partitions I added dynamicly will not appear in the solution and would be overwirtten, when I would deploy then changed cube.

How do you handle this? Do you create a new solution that is accessing the cube on the SSAS-DB? If yes, what is your solution, if someone accidently drops the cube or it gets currupted in anyway?

Cheers,
Mitch

Post #1407151

christian.terhart

Posted Thursday, January 17, 2013 6:27 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 25, 2013 7:31 AM
Points: 83, Visits: 364

no opinions?

Post #1408388

stevefromOZ

Posted Thursday, January 17, 2013 11:15 AM

SSCommitted

Group: Moderators
Last Login: Today @ 7:06 AM
Points: 1,764, Visits: 3,200

If I open the solution that I created for the cube, the partitions I added dynamicly will not appear in the solution and would be overwirtten, when I would deploy then changed cube.

Correct, the partitions won't appear in your local, on your HDD solution file, but they do exist.

How do you handle this? Do you create a new solution that is accessing the cube on the SSAS-DB? If yes, what is your solution, if someone accidently drops the cube or it gets currupted in anyway?

You can create a new solution or (usually not recommended) connect to the live/Prod DB on the server. To do the first, follow the instructions in this post http://www.sqlservercentral.com/Forums/Topic786526-147-1.aspx - Note, for 2012, it's now simply "Import from Server" so you can import MOLAP or datamining models.

to connect to the Live - use File|Open| Analysis Services Database, and then choose the server and DB to connect to. Believe you can also save a solution file once you've finished doing what you're doing.

Steve.

Post #1408552

christian.terhart

Posted Friday, January 18, 2013 1:39 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, April 25, 2013 7:31 AM
Points: 83, Visits: 364

Thx Steve,

I will give it a try.
I am little concerned that the developers confuse the "original" with the "live"-Solution and overwrite the cube with an old version.
I have to find a way that this will not happen.

Cheers,
Mitch

Post #1408752

« Prev Topic | Next Topic »

Permissions