Most likely his cube xml file is corrupted that needs to be rebuild. This information can be easily Googled by type in "adoredErrorResponseException the following file is corrupted" as search string in Google.
The steps to resolve the issue are as follow:
1. Go to Services control panel to stop SSAS
2. Go to the path: C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Data (the text in red changes with the version of SQL installed so it need to be adjusted accordingly). Find the XML file stated in the error message then delete the file. There should also be a folder with the same name, also delete this folder.
3. Go back to Services control panel to start the SSAS.
4. Go to SQL Management Studio to connect to Analysis Services server which the target cube database is located. Find the problem database then right-click to select Process to re-process the problem cube.
Once processed, try to run the report again in Analyzer to see if the problem is resolved.
0 Comments