Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Shared Dimension DataSources

Status
Not open for further replies.
GavMc

GavMc

MIS
Jul 17, 2002
8
GB

I have an Analysis Services Database which contains 1 DataSource, and several Cubes and Shared Dimensions.

The problem is that I want to change my DataSource so that all the Shared Dimensions (and cubes) will use the new DataSource. I know that I can edit the existing DataSource details to point to another database, but it will retain its original name - I was wondering if there was a better way?

Any help would be greatly appreciated.

Thanks,
Gavin.
 
Status
Not open for further replies.

Similar threads

Benedito Almeida
  • Locked
  • Question
SSAS - Hide Some Calculated Members for a Time Dimension Level
Replies
0
Views
370
Benedito Almeida
Benedito Almeida
juanvg1972
  • Locked
  • Question
Problems linking dimension tables and fact tables in SSAS cube
Replies
0
Views
355
juanvg1972
juanvg1972
burakcan
  • Locked
  • Question
How to hide unwanted dimension values in SSAS cube
Replies
1
Views
604
Motlatjo
Motlatjo
JP_Quinn
  • Locked
  • Question
Adding New Column to Dimension Table, Used in Other Cubes, Must I Update the Models of Other Cubes?
Replies
0
Views
441
JP_Quinn
JP_Quinn
Motlatjo
  • Locked
  • Question
All Dimensions showing on Excel, but only 3 showing on SSMS
Replies
0
Views
340
Motlatjo
Motlatjo

Part and Inventory Search

Sponsor

Back
Top