Sign Up for Training |
insightsoftware Company Site
Community
Downloads
Training
Submit a Request
Become a Jet Insider
Give Feedback

Error: Errors in the metadata manager. No Dimension Relationships Exist within the 'X' measure group.


Symptoms

When a user right-clicks the Dimensions node on the Cubes table and deploys all dimensions, the following message is displayed:

"Microsoft.AnalysisServices.OperationException

Errors in the metadata manager. No Dimension Relationships Exist within the '{name of measure}' measure group."

Resolution

When dimensions are deployed, they are individually removed from any cubes that they are associated with at the time of deployment.  As a fundamental rule, all cubes need to have at least one dimension associated with them.

When a user tries to deploy all dimensions without also deploying the cubes, at some point there is going to be a cube that no longer has any dimensions attached to it. This violates a fundamental requirement in Analysis Services and the error is thrown.  This is also true when a dimension is deployed - as the cube that this dimension relates to is taken offline.  If all dimensions are deployed, the result would be that all cubes would be taken offline.

Since the cubes would need to be processed anyway, it is necessary to deploy and execute both the dimensions and the cubes when it is desired that all dimensions be deployed and executed.

Was this article helpful?
0 out of 0 found this helpful

Comments