Can anyone please tell me about how easy it is, and whats involved, in changing an OLAP cubes data-source ? My company is looking to move the relational star-schema data from SQL Server to Oracle, but still process the cubes from SQL Server Analysis Services, therefore, hopefully we should just need to change the data-source..
Is it more complex that than, will the cubes need to be re-processed ? I cant seem to find any article on this from people who have gone through this issue before...
Thanks very much,