Hi there,
Does anyone know how to alter the data source of a cube. I have had to move my cubes to another analysis server. I used copy and paste to move them and it worked fine. The problem is the database it accesses is different and I need to use a different data source and other than redoing all the cubes is there a way I can modify the data source for the fact table, and dimensions of the cubes?
Thanks in advance.
Does anyone know how to alter the data source of a cube. I have had to move my cubes to another analysis server. I used copy and paste to move them and it worked fine. The problem is the database it accesses is different and I need to use a different data source and other than redoing all the cubes is there a way I can modify the data source for the fact table, and dimensions of the cubes?
Thanks in advance.