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?