Refresh option in DSV
Refresh option in DSV


Lets have a small discussion about one of the most important options available in SSAS Data Source View i.e “Refresh”. I have never given or taken an interview with out discussing about this option. This is such an important option available in DSV. When ever there are changes occured in the schema of the underlying data source then yu can use REFRESH option in dsv to incorporate all the changes to the tables in the DSV. Refreshing a DSV updates the whole data source view.

You can find the option available in the RIGHT CLICK on DSV. PFB the screenshot showing the same.

Refresh Option
Refresh Option

Lets assume we have 10 tables added in DSV to design a cube and if there are any schema changes occurred in database level for these 10 tables. If you select on REFRESH option then it will go to the database and check for the changes occurred in these 10 tables and update all the changes to the tablels in DSV. The type of schema changes include –

  1. Primary key defined or removed.
  2. Foreign key relationship defined or removed.
  3. Column Added or Removed.
  4. Table Removed.

To demostrate the same I added one column “TEST” to DimCurrency table which is part of the DSV I designed and removed one column “DISCOUNTPCT” from the table DimPromotion and then I select Refresh in DSV and PFB the screenshot showing the list of changes occured in my underlying data source.

Refresh Report
Refresh Report

Be careful in refreshing the DSV. You can either update all the changes or reject all the changes. We cannot update Few changes ignoring the remaining. If you defined an attribute/measure using a column and that column is removed then it will remove that attribute/measure from the cube. You can you “Save Report” option available in the wizard to save the report about the changes that are updated on Refreshing DSV for your future reference.

Refreshing a data source view is based completely on the names of the underlying objects. Therefore, if an underlying object is renamed in the data source, Data Source View Designer treats the renamed object as two separate operations—a deletion and an addition. In this case, you may have to manually add the renamed object back to the data source view. You may also have to re-create relationships or logical primary keys.

That’s it and Happy coding !


Roopesh Babu V



  1. The administration of tamoxifen, 20 mg day for 10 days, to normal males produced a moderate increase in luteinizing hormone LH , follicle-stimulating hormone FSH , testosterone, and estradiol levels, comparable to the effect of 150 mg of clomiphene citrate Clomid. clomid cost Clinical characteristics at baseline and changes from baseline after 10 13 wk of treatment.

  2. Body image issues after bilateral prophylactic mastectomy with breast reconstruction in healthy women at risk for hereditary breast cancer п»їcialis In addition, a potential estrogen response element sequence has been located in the first intron of the mouse LPL gene 140

  3. [url=]best over the counter teeth whitening[/url] strongest over the counter painkillers

  4. Whey represents the bulk of the amino acid content in protein, accounting for around 95 of protein in the human diet, best peptides to increase testosterone buy cialis non prescription I was told there was no side affects besides puncturing your uterine wall when inserting it or that it could slip out


Please enter your comment!
Please enter your name here

15 − 11 =