Updating data source schemas for cubes

I have built a data source view and a cube.
The datawarehouse is in the design phase and the management is not yet sure about the desired facts. So that I have and I have to do a (small) redesign of the database from time to time add/delete columns for the underlying tables.

Since now, I'm always recreating the cube, which is a little time consuming.

Is it somehow possible to update the data source view and the cube in VS to the current table schemes I can replace the tables in VS, but the scheme will stay the same. No additional columns are recoginzed ...

Answer this question

Updating data source schemas for cubes

Starsearch

You can also just right-click on the background of the DSV and one of the menu items is "refresh".

_-_-_ Dave
benze
Try replacing the table with a named query, saving, and then replacing with the table again. This should force it to re-read the database and update the .DSV. I recently had a similar situation and this worked for me.

-D
Usman9852000
It works great. Thanks
Updating data source schemas for cubes

Answer this question