DSV Refresh

Hi,

I have an odd problem with the creation of objects in the data source view using AMO.

I added some tables and relations with AMO and everything seems to work well.

Then, using Analysis Services I selected the data source view and refreshed it.

The form that notifies the changes in the data source view showed a lot of changes that I didn’t understand, costraints created and removed, fields changed and other operations that I didn’t made...

I try to do the refresh with AMO using all the update and refresh options I found but with no results.

Every insight on the question will be of great help.

Thanks

This is an extract of the data source view refresh report:

Object

Change

_DIM_DimColl1

Changed

Constraint1

Deleted

_DIM_Dimensione

attrfinto

Changed

_DIM_eta2

aaa

Changed

_DIM_Mesi

Changed

_DIM_MesiColl

Changed

Constraint1

Deleted

_FK_eta2_aaa

Changed

Constraint1

Deleted

_FK_MesiColl_Livello03

Changed

Constraint1

I don't have a clue what's causing that, but let me suggest that you keep a copy of the .dsv (XML) file from before you refresh the DSV. Then you refresh it, save it, and do a diff versus the previous file. Then you can see exactly what properties changed. There's a pretty close mapping between AMO properties and the XML elements in the file.|||The refresh in AMO is different from the refresh in DSV diagram. DSV Diagram refresh will connect to the relational database and refresh the metadata. AMO refresh will not connect to relational database and just refresh the objects within AMO.|||

Do you know how can I refresh the DSV through AMO?