January 15, 2013 at 4:18 am
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
January 17, 2013 at 6:27 am
no opinions?
January 17, 2013 at 11:15 am
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.
January 18, 2013 at 1:39 am
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
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply