Data Source.
I am not able to change a data source of the cube.
I have data source which points to Development database.
Now, I need to point to QA database. (Database structure
is the same in both databases).
I can add a new data source and I would like to change
Cube's data source property , but it is impossible.
I decided to keep an old (development) data source name
but, edit it to point to QA database.
But, when I process it returns 0(zero) rows.
So, do I have to recreate all my cubes and dimensions with
a new data source?
Is there any way I can change data source of the cube?

Thank You!

Hi,

renaming a data source is NOT supported in SQL Server 2000.

Best practice: Don't use a server or database name when 'naming' an
Analysis Services data source (inside a database). Instead use a logical
name that represents the type of data being supplied by the data source.

Once you start creating objects, the data source name is embedded as part
of other objects. Thus we recommend that you use a "logical name" for the
data source. That way when you move from dev to QA; QA to production, you
can change the underlying server name and database without feeling a 'need'
to rename the data source.

HTH,
Bas