January 17, 2008 at 3:56 am
Is there a way to change the DSV of an existing cube?
I have the need to build a new cube based very similar to an existing cube. No I can copy the existing DSV, creating a new DSV, and make the amendments to that.
I can copy the existing cube, creating my new cube, but see no way of changing it to point to the the new DSV???
Anyone?
January 17, 2008 at 1:13 pm
Hi,
it is no problem to change the data source view. You have several posibilities:
Open Bi Development Studio - Open - Analysis Services database - choose your server and olap database. Now you are online connected to the cube and could edit the existing structure of the DSV.
Another way is to create a new project - choose BI Projects - Import Analysis Server 9.0 database - this will download the structure of your cube to a new SSAS Solution. This you could edit offline and then Deploy it to the server.
If you want to leave your current olap database unchanged and create another olap database you have to do it the second way, do the changes in the dsv, cubes and whatever and then change the database name before deploying it to your server. Then a second database would be created on your server.
Hope this helps.
SK
November 30, 2011 at 11:36 am
go to the code view of the dimension and change DataSourceViewID to new data source view.
hope this might help you
for more information
http://dineshpathirana.blogspot.com/2011/11/how-to-change-datasourceview-of.html
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply