Search code examples
ssas

SSAS : Errors in the metadata manager

I am working on an SSAS project which is deployed at several customers and which works well for the majority. the problem is that there are clients for whom access to the cube from Excel is blocked by having this error message: Errors in the metadata manager. An error occurred when loading the 'Compta' cube, from the file, '\?\E:\SQL\MSAS13.CEGIBI\OLAP\Data\Bi_AnalysisServices.33.db\Compta test.1189.cub.xml'. the problem disappears when you connect to the Analysis server from SQL Management Studio.

I Tried to stop Analysis Servies ,delete the instance and redeploy it and it didn't work. Does anyone has a solution for this problem ?

Thank you for your help.

Solution

  • I found the origin of the problem. its a program that restarts SSAS Services to refresh memory :

    net stop MSSQLServerOLAPService
net start MSSQLServerOLAPService

    that script doesn't work correctly and u need to open SSMS to have acces to the cube via EXCEL.