If your SSAS database is corrupted, then you can either 1) restore the database or 2) delete the existing SSAS database and then process the cube to load the fresh data.
I would like to share the second one: Delete the existing database and then process the SSAS cube to load the fresh data.
For example, my SSAS database 'HelloWorld' got corrupted and now you would like to fix the SSAS database, so following steps should be taken to fix it.
Step 1: Delete the existing database
|Fig: Find your corrupted database|
Hit the delete button
|Fig 2: Delete the database|
Since database is deleted, now we can open SSAS package and hit the process button to deploy and process it as like below:
Fig 4: Deploy the SSAS Cube
However, if we may unfortunate sometime when you will find error like :
|Fig 5: Deployment error|
Step 2: Delete the .xml file from data directory
To fix the error we need to delete .xml file from the data directoy, Depend on your Windows version (32/64 bit), you can go to data dictionary and delete the xml file
C:\Program Files\Microsoft SQL Server\MSAS11.TABULAR\OLAP\Data
The XML file format will look like: <CubeID>.<VersionNum>.db.xml, e.g. this case: HelloWorld 1.0.db.xml . You can also delete the folder as like same name: HelloWorld 1.0.db
|Fig 6: Deletete the .xml file|
Step 3: Restart the SSAS
Restart the SSAS
|Fig 7: Restart the SSAS|
Step 4: Run the SSAS package
You are all set to process the cube. So open your SQL Server Data Tools and SSAS solution, process the cube and you will be able to load fresh data structure and the data, it means your databse is back again and functional as like before.