Changes to Fact table

[elmax]

I have a fact table in sql server that I want to add a new column to. when I do that and I try to update my data source view in analysis services it removes the rest of the changes I made to the data source view (like added foreign keys and such).

Is there a way for me to bring the changes into the data source view without losing my modifications that were made within the cube?

 

[MDXer]

have you tried to refresh dsv?

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[elmax]

I have - that is what wipes out the changes I made to the data source view it brings in the changes from the data source but the calculated columns and relationships I added within the data source view are gone.