Change Data Source for Shared Dimensions

Printable View

06-21-2005, 06:11 PM
KingSQL

Change Data Source for Shared Dimensions

I have an archive of an Analysis Services database that was created on a server that is not accessible to me. I also have a copy of the source SQL Server database that it uses as a data source. I have restored both of these to my server. I have figured out how to change the data source to point to my server for the fact tables referenced, but I can't figure out how change the data source for the shared dimensions. I would like to be able to do work on this version of the database, but I get errors when I try to browse the dimension data because it can't connect to the original data source. Any ideas?
06-21-2005, 10:54 PM
Stephen

The data source for the dimensions used by a fact table must be the same as the fact table.

If you are getting errors when trying to edit the dimensions then there must be 2 data sources in the catalog you are using. Even if both data sources point to the same database, the fact that they are different data sources and can potentially point to different database means that AS does not permit dimensions used in a cube to use different data sources.
06-22-2005, 05:45 PM
KingSQL

OK -- Let me ask the question another way... Given that an AS database is created in a Dev environment, how do you then migrate it to another environment, such as Test or Prod, so that the cubes are processed against the Test or Prod data sources?
06-22-2005, 05:49 PM
Stephen

Archive the dev catalog, restore it into the target environment, change the properties of the data source and do a full process of dimensions and cubes
06-22-2005, 05:55 PM
KingSQL

Great. That did it. Thank you!
07-22-2005, 10:18 AM
mugurel_ptr

Acces an remote OLAP Server

I try to access an OLAP Server from a remote compute, using ADO MD Library with following string conection :
"Datasource=SERVNAME; Provider=msolap; Initial Catalog=FoodMart 2000;"
I recive the following error code: -2147467259 (0x80004005), "Unspecified error"
Can sombody help me
07-22-2005, 10:21 AM
mugurel_ptr

Quote:

Originally Posted by mugurel_ptr

I try to access an OLAP Server from a remote compute, using ADO MD Library with following string conection :
"Datasource=SERVNAME; Provider=msolap; Initial Catalog=FoodMart 2000;"
I recive the following error code: -2147467259 (0x80004005), "Unspecified error"
Can sombody help me

Sotty for appling here. My intention was to open an new topic on forum