Changing a cubes DSV ?

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