SSAS Errors: Errors in the metadata manager. The dimension with ID of ‘Something Name’ referenced by the ‘CubName’ cube, does not exist.


The steps to fix the problem:

1. Stop SSAS service(any way you know);
2. Rename (or delete) the data file folder (example: …OLAP\Data\My Cub Name.0.db\”;
3. Start SSAS service and Connect through SSMS to delete the SSAS database.
4. Redeploy cub database from BIDS and it should work this time.

A useful post to help to solve this problem is from:

SSAS errors: Errors in the metadata manager. The dimension with ID of ‘xxx’ referenced by the ‘yyy’ cube, does not exist.



Leave a comment