HELP! I've lost a SSAS "cube" due to a "File ==> Save as XML"

Then, the cube name became XML, listed under the "Assemblies"... and, then made the mistake of "deploy-ing"... and of course, didn't have a backup... It appears all of the recent "calculations" added to the cube are contained within the xmla file, yet the cube still looks like it is missing from the VisualStudio 2005 (VS2005).

Over in the SS Management Studio (SSMS), I tried wrapping the "Alter AllowCreate..." around the cube XML, and that seemed to work, so that now the Cube appears within the SSMS... However, I can't seem to find a way to open it up with VS2005, and see the cube name/measures, as I can see them within SSMS...

Thanks in advance for your help!

Hi Al,

If you can see the cube in SSMS then what you should be able to do is in BIDS (BI Developer Studio) go to File/Open then choose Analysis Services Database, specify the Server Name and Database name. You can put this to a new solution if you need to.

Once you click OK it will have a direct connection to the cube on the server where you can modify things.

Hope this helps,

David Botzenhart

|||

Thanks... I had proceeded to click on the XMLA file (which was actually within "Miscellaneous", instead of Assemblies), and then used "File ==> Save as Cube", which worked, for the most part... Also, apparently, I also saved the DSV as XML, which lost the relationships between the source tables... After I reconnected the table relationships, then the CUBE deployed successfully...

Thanks for the quick reply

p.s... Moral to the story, if you want to backup XMLA script file, then utilize the Deployment Wizard, and click the box to "create the script".... and/or Backup the source and/or SSAS database regularly