REFRESH property in SSAS DSV

24
6597

Friends,

This is very important option provided by Microsoft for SSAS and it is very important interview question too. Don’t expect an interview with out having a question about this REFRESH option. Let’s see complete story about this REFRESH option here.

Firstly, lets see where this option available in SSAS BIDS environment. You can find this in Data Source View in short DSV. IIf you open DSV and right click on Vacant area then you can see context menu items among which one is “Refresh”. PFB screenshot showing the Refresh option in DSV.

Now let’s see the use of this option. Let’s say I added  10 tables to my DSV and dimensions and Measure groups are defined and the cube is built. Now I got a new requirement which lead to structural changes of the tables that are used in DSV. Structural changes includes

1) Adding a column to a table or view

2) Deleting a Column

3) Removing or adding Primary Keys

4) Removing or Adding Relationships

If you wish to get all the structural changes happened to the tables that are part of DSV then REFRESH is the option. If you click on REFRESH then it will check in database for changes happened to the tables in DSV and will prompt us to Add the changes to DSV.

Example – In the DSV shown in the below screenshot a  table “DimCustomer” is added.

Now I am adding a new column to this table in Database with the name “Address” using the below query –

Alter table DimGeography
Add Address Varchar(100)

To pull this column into DSV table I can do the following things.

  • Removing Table from DSV and Adding it back
  • Using Refresh Option

If you use the First option listed above and when u remove the table from DSV then all the objects created like Dimensions,Measure Groups,Relations ..  using this table will get deleted. This will be very risky and not a best option to pull the changes into Cube. So, The best option is using Refresh button. If you select refresh option then it will show you the changes occurred  in database level as shown in below screenshot –

If you select OK then the changes will be updated to the tables in DSV. The only Disadvantage with this option is you have to accept all the changes or reject all the  changes. You cannot accept partial changes by rejecting the remaining. Either Full or Null.

That’s it .. Happy Coding !!

Regards,

Roopesh Babu V

24 COMMENTS

  1. With such a group of people holding back, and even how to cope with erectile dysfunction confrontation, it was natural for Lu Duoxun and Yang Tingzhang to buy cialis online united states not progress smoothly in the Guassa mission buy cialis uk The combination of Cialis and more than one alcoholic beverage can lead to heart problems and changes in blood pressure

  2. While some of the ingredients in Roman s Testosterone Support supplement have individually been shown to improve libido and sexual functioning in men in some studies, this specific supplement has not been tested priligy reviews Followed at 2

  3. You’ve never had a better time with a mere makeup bag than with this clear PVC version adorned with sequins from J.Crew. Wave goodbye to simplicity and hello to a good time on the go! As a parent, you naturally have to carry your kids’ things too. Trust us — this bag can take it all. It can handle multiple full size bottles (double the travel size!), it hangs for easy access, and is super durable. One reviewer raved about the bag and said, “Ellis James Designs’ Hanging Toiletry Bag is a complete game changer in terms of staying organized when you’re constantly on the go. I never really put much thought into what brand organizer I purchased until I tried out Ellis James’s tall makeup organizer first. The size, durability, and versatility of that bag opened my eyes to what I was missing out on and the attention to detail that this brand puts into their products cannot be beat!” https://selfken.com/community/profile/gilbertog309927/ 24HR WEARCo-created with our pros and tested in extreme conditions, Aqua Resist Color Pencil and Smoky Shadow are waterproof, sweat-proof & transfer-proof. With a few seconds of playtime, these revolutionary formulas quickly set in place and stay on until you take them off. Benefits: Anytime you get anything in your eye, you should promptly flush it out with water. If your eye still feels irritated or looks inflamed after doing so, call your physician for directions on the next steps. Following the launch of its highly-anticipated Aqua line and became one of the global leaders in waterproof makeup, MAKE UP FOR EVER reinvented the AQUA range and improved it with new shades and formulation to resist to extreme conditions, to become AQUA RESIST. Subscribe for special sales and early access to brands you love.

  4. Wood GC, Hanes SD, Croce MA, Fabian TC, Boucher BA 2002 Comparison of ampicillin- sulbactam and imipenem- cilastatin for the treatment of Acinetobacter ventilator- associated pneumonia. buy doxycycline In a kennel, Lepto is not often noticed or diagnosed, unless you are looking for solutions to puppy death one or two stillborn puppies or a puppy that dies shortly after birth usually isn t sent for diagnostics.

  5. On the other hand, there are elements of the virtual gaming market that are entirely legal and regulated here. The most prominent example is that of the sports betting industry, which has a long history in the country. There are many licensed bookmakers who offer a wide range of bets for punters on sporting events taking place all over the world, and these companies are also allowed to take bets over the Internet. There is one exception to this rule: in-play betting is not allowed online, as bookies may only take wagers on events already in progress at a retail location or over the phone. Some operators have found ways around this, though these loopholes will likely be closed soon. Combining the thrilling games, electrifying features including tournaments and lots of surprises. LuckyLand Slots is quickly becoming a favourite with a large number of social casino enthusiasts. https://egerkek.com/community/profile/zvvtanesha8722/ Bitcoin gambling should only be done at the top Bitcoin casinos – that means legal and licensed casinos with a good reputation. What we mean by this is that you should still look for all the things that you’d normally do when choosing an online casino, including a reputable licence, third-party certification, affiliations and customer support. CryptoDice github.com felinegambler CryptoDice CryptoDice github.com felinegambler CryptoDice Each casino has its own rules. You can view this information by reading the payment terms of an online casino. Usually, casinos offer more flexible cryptocurrency minimums and maximums – so you may even be able to withdraw an unlimited amount of cash using crypto. With a no-nonsense name, Bitcasino is the fifth-best online Bitcoin casino. Its website, like its name, is simple and to the point. However, it offers all the games that players could need and is one of the few casino sites to offer esports betting.

LEAVE A REPLY

Please enter your comment!
Please enter your name here

61 + = 66