Recreating an Analysis Services Project

Well, continuing our story about strange things that can happen, I thought I'd share with you this little tidbit. I was taking over a project from someone who had left the company a while back. In the cube that was on the old server, there was an MDX calculation. Only thing was that calculation was missing from the project on the new server (and I admit I couldn't guess what was behind it).

So what can you do when you need something that in a project of an old cube? You import the project back to you! The way to do that is to open the Microsoft Visual Studio 2005 and go to File > Open > Analysis Services Database. You fill in all the details of the relevant server and the project's name and you can recreate the project on your PC again. Calculation resurrected.