Friends,
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.
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 –
- Primary key defined or removed.
- Foreign key relationship defined or removed.
- Column Added or Removed.
- 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.
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 !
Regards,
Roopesh Babu V
rybelsus cost buy semaglutide online rybelsus price
buy semaglutide online: semaglutide – rybelsus cost
Compare sales and discounts to order levitra online no prescription , always look for online deals and discounts
We subscribe to the HONcode principles of the Health on the Net Foundation.
Чтобы начать выигрывать, скачайте БК на Android и начните делать ставки прямо с вашего телефона
Best Apps to Make Money in Pakistan, Simple Ways to Make Money in Pakistan Through an App, That You Didn’t Know About, Optimal Apps to Make Money in Pakistan, The most effective applications for earning money in Pakistan, Earning money in Pakistan using applications: is it real?, Legal applications for earning money in Pakistan, Innovative platforms for earning money in Pakistan, How to make money, without leaving home in Pakistan, Simple ways to make money in Pakistan through mobile apps, Successful ways to make money in Pakistan, Original ways to make money in Pakistan through apps, for making money in your free time, Easy ways to make money in Pakistan through apps, Effective apps for making money in Pakistan: check it out yourself, which will help you achieve financial stability, for making money at any time of the day, which will open up new opportunities for earning moneyhow to earn money online in pakistan without investment how to earn money online in pakistan without investment .