Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How do you service your Cubes if using dynamic partitioning Expand / Collapse
Author
Message
Posted Tuesday, January 15, 2013 4:18 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, May 17, 2014 5:41 AM
Points: 93, Visits: 425
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
Posted Thursday, January 17, 2013 6:27 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, May 17, 2014 5:41 AM
Points: 93, Visits: 425
no opinions?
Post #1408388
Posted Thursday, January 17, 2013 11:15 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Monday, July 14, 2014 10:41 PM
Points: 1,814, Visits: 3,453
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
Posted Friday, January 18, 2013 1:39 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, May 17, 2014 5:41 AM
Points: 93, Visits: 425
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 »

Add to briefcase

Permissions Expand / Collapse