I have a single connection that pulls through 3 tables (fact, 2 dims)
I now need to change the source of ONE of the dims to a view on a different server/database
How do i do this? deleting the dim from the model isn't an option as it'll break relationships/dax/measures etc etc
The only way i can think of is to use the database the source is currently pointing to as a 'dsv' and create a view that uses linked servers to pull the data from the new dim on the new server.database, but this seems like an awful solution!
Do i need to go into the xml manually change stuff? is that even possible?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.