I’ve been working a little with MS Analysis services lately. Yesterday I came across this error message:
Errors in the OLAP storage engine: The metadata for the statically linked measure group, with the name of XXX, cannot be verified against the source object.”
The error message is self explaining. I did indeed have more than one cube, and some of the cubes where linking to another. I had, however, been running with this setup for a long time, and never seen this problem before.
After some googling and som trial and error, I found a solution to the problem. It is not pretty, but there was nothing else to do 🙁
Delete the Analysis services database
Deploy the cubes without processing
Process the cube(s) that are being linked to
Process the whole database
As I said before, it’s not at pretty solution, and I must admit I’m little curries about next time I have to deploy the cube.