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:
http://sqljoe.wordpress.com/2011/03/22/ssas-errors-in-the-metadata-manager-the-dimension-with-id-of-xxx-referenced-by-the-xxx-cube-does-not-exist/

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s