If you are like me and have ever made a mistake while working in bids on a cube you may want to restore your bids environment as it was when you last processed your cube. This is actually quite easy to do but sometimes hard to find. So I decided to walk you through this very useful feature. First you open up your bids environment and click new Project as below:

Screen clipping taken: 6/28/2010, 8:55 PM

Now you can select the template for import analysis services 2008 database:

Make sure and name your project, set the location and the solution name. When the wizard screen pops -up just click next and the source database selection screen will appear. Now select the server that you wish and the database you wish to import.

After selecting the database click next and the wizard will start populate your package.

And there you have it that’s all there is to it