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 derfloh 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
Joined
Jul 17, 2002
Messages
8
Location
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 Question
SSAS - Hide Some Calculated Members for a Time Dimension Level
Replies
0
Views
596
Benedito Almeida
Benedito Almeida
juanvg1972
  • Locked
  • Question Question
Problems linking dimension tables and fact tables in SSAS cube
Replies
0
Views
587
juanvg1972
juanvg1972
burakcan
  • Locked
  • Question Question
How to hide unwanted dimension values in SSAS cube
Replies
1
Views
1K
Motlatjo
Motlatjo
JP_Quinn
  • Locked
  • Question Question
Adding New Column to Dimension Table, Used in Other Cubes, Must I Update the Models of Other Cubes?
Replies
0
Views
713
JP_Quinn
JP_Quinn
Motlatjo
  • Locked
  • Question Question
All Dimensions showing on Excel, but only 3 showing on SSMS
Replies
0
Views
605
Motlatjo
Motlatjo

Part and Inventory Search

Sponsor

Back
Top