Copying a cube but using a different data source

Hot Topic

How to avoid textfield implicit keeptogether?
Accessing SQL Mobile Databases in VB2005 - Pocket PCApp
Problems deploying to a different server
Native XML in SQL Express 2005 same as SQL 2005 standard, workgroup and enterprise?
report authentication: windows prompt removal
issue with debugging script components with names that start with "R" or "P"
Can i access SQL Login Users in ASP.Net application
Full Text Search - Thesaurus
Subscriptions- How to enable?
Problem with SSIS Transaction...Transaction Scope

SQL Server

How to hide the tables and table relations to end user.
Running an INSERT statement a @variable without using EXEC
Reporting Services Key Management
SQL 2005 Standard Replication
programmatically extend project tree
Fit Table on one page if possible
Object Explorer/Server Explorer Error
cannot install Northwind database in SQL Server Express
Migrating RS
Dialog Security and Message Encryption

Copying a cube but using a different data source

We have a cube that we've been using for a while. I need to make several more cubes with the exact same schema and roles and everything else...just with different data sources. The other data sources have the same schema as the database the original cube is using. I know that when you copy a cube and paste it, the data source is copied over too. And I've read that you can't change the data source of a cube.

My question is what is the easiest way to create the new cubes Or do I have to create every new cube from scratch (pain in the butt)

Thanks in advance for your advice.


Answer this question

Copying a cube but using a different data source

  • Catherine L D

    Yeah, I thought about that but we have another cube using the data source so that option is out. Looks like I will need to create the each new cube from scratch. : (

  • Frank Babz

    After you made a copy of your project, create a new DataSource to point to your new relational DB. Open DSV in Xml Mode, change the tag <DataSourceID>...</DataSourceID> to point to your new data source ID.

  • SdwOne

    Oh AS2000 is total different story then. There is no DSV concept in AS2000. You can try changing the connection string in the same data source rather than switching the data source on the cube.

  • anurag chauhan

    Thanks Ken. We're using AS2000. Is there a DSV equivalent

  • Dr. Mojo

    Thanks Sasha!

  • jankoesp

    Go to every partition of this cube, edit it, and then change the data source. This should do a job.

  • Copying a cube but using a different data source
Answer this question