Change the data source to a cube RRS feed

  • Question

  • Hello,

    I took a complete BI project, which I realized with SSIS, SSAS and SSRS (2008), to test it in another pc, in the SSIS I didn't have many problems, but in the SSAS I had to create a new data source even if it is the same database (I have attached the old one in SQL Server's new PC), so I created new sources of data, now for cubes I do not know if there is a way to change the data source of a cube, so I changed the old data sources by the news, and it will be cool, if not, I have to create new cubes and repeat the above calculated members which is very heavy

    And thank you in advance
    Tuesday, May 24, 2011 11:02 AM


  • If you are refering to change the connectionstring of an existing Analysis Services data source, you can do this:

    * In you are in BIDS (Visual Studio) project, double clic the data source file (.ds), the Data Source designer pops up.

    * In project is already deployed, browse using Object Explorer using SQL Server Management Studio: Your SSAS Instance>Your SSAS Database> Data Sources> Your Data Source. Right click Your Data Source, Script Data Source As> Alter to> New Query Window. Here you have the XMLA script for your data source. Update the <Connectionstring> element with the new connectionstring. Click the execute button (F5) to send updates to the server.


    Hope this helps.

    Alan Koo Labrin | "Microsoft Business Intelligence y más..." http://www.alankoo.com
    Wednesday, May 25, 2011 2:58 PM