I have made some changes to the hierarchies in a single dimension within a SSAS 2008 project - sorry for posting in wrong section but it applies to 2005 as well I hope.
I want to update these changes to my cube that is running on an Analysis Server TEST environment.
I only understand that I can do this by redeploying the whole cube?
However I do not want to redeploy the whole cube because if I redeploy the whole cube I lose all my permissions created on the cube and have to recreate them all the time which is very time consuming.
Is this possible to update a dimension without redeploying the whole cube and if so how do I do that?
The only way I have understood to update the cube with new dimension changes is to rebuild and redeploy?
Any help appreciated 🙂