Is it possible to change the DSV used by an existing cube in the designer?
Alternativeliy I thought about scipting a new cube and change the:
<DataSourceViewID>dsvname</DataSourceViewID>
The only way I found for changing the cube’s DSV in the UI was through recreating the cube. But you can certainly run a cube alter script that changes all instances of the <DataSourceViewID> to the DSV ID of your choice. Tried it using Adventure Works sample project and worked fine.
Hope this helps,
Artur
sql
