How to update SSAS 2008 dimension without redeploying whole cube?

Question

How to update SSAS 2008 dimension without redeploying whole cube?

lorenzdominic_

Old Hand

Points: 334
More actions
March 13, 2012 at 5:41 pm

#265766

Hi all,
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 🙂
Dom

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Log into SSAS using SSMS.

Locate your cube database, open the dimensions and right click on the dimension that you want to change. Choose Script Dimension As and select ALTER To. This will generate a XMLA script that will alter the dimension. Run this script on the other server.

Don't forget to process your dimension afterwards.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

lorenzdominic_ Old Hand Points: 334 More actions · Answer 2

thanks for your help.

I understand that this might be the process for updating the Production environment with changes from the TEST.

Is that correct?

thanks

Dom

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

There are several ways to deploy a cube from one environment to another, and this is one of them.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 4

http://sqldb.wordpress.com/2006/06/23/deploying-an-analysis-services-database-into-the-production-environment/

this wud be a good place to start. you should understand each option and decide which is best for you.

Jayanth Kurup[/url]

SQL Server Youngling Old Hand Points: 360 More actions · Answer 5

Jayanth_Kurup - Thursday, March 15, 2012 12:42 AM
http://sqldb.wordpress.com/2006/06/23/deploying-an-analysis-services-database-into-the-production-environment/this wud be a good place to start. you should understand each option and decide which is best for you.

sqldb.wordpress.com is no longer available.

This site has been archived or suspended for a violation of our Terms of Service.
For more information and to contact us please read this support document.

copied and pasted above on 15 Jan 2019