How to update SSAS 2008 dimension without redeploying whole cube?

  • lorenzdominic_

    SSC Veteran

    Points: 218

    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

  • Koen Verbeeck

    SSC Guru

    Points: 258888

    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_

    SSC Veteran

    Points: 218

    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: 258888

    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

    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

    SSC Veteran

    Points: 250

    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

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

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