SQL Server Performance Forum – Threads Archive

Change Data Source of a Cube

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

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.

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

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.

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

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

]]>