SQL Server Performance

Change Data Source of a Cube

Discussion in 'Analysis Services/Data Warehousing' started by gortij, Jun 16, 2005.

  1. gortij New Member

    How can I change the Data Source of a Cube. The New Data Source is pointing to the same DB except it has a different name. The "Data Source" property is greyed out in the Cube Editor.

    Any tips or pointers would be helpful.

    Thanks

    JPG
  2. satya Moderator

    If you edit the partition of a cube, it shows you the data source and the fact table and there's a "Change" button that allows you to change them.

    Make sure you're using proper privileged account to change so.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  3. gortij New Member

    This changed it just for the Partition, but the Cube in itself was still attached to the old Data Source.


    JPG
  4. satya Moderator

    How about the account privileges you're using on that cube?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  5. gortij New Member

    I dont know if I am answering your question Satya, but I am an OLAP Admisnistrator.

    If there is something else I need to look at, please let me know.



    JPG
  6. gortij New Member

    I think I found the answer to my question. Here is what Microsoft says and I quote "If you do not change the name of the data source object before you create objects in the database, you will not be able to change the name of the data source object without using third-party utilities. For more information on tools you can use when moving a database between Analysis Services instances, see 'Release Management' later in this paper."

    So essentially I am doomed (until atleast till I try to figure out how to use the 'Utilities' that MS is talking about)

    Good news is you can change the Database to which your DataSource is pointing. (which is what I doing now).


    JPG

Share This Page