Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
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 an "Errors in the metadata manager. No Dimension Relationships Exist within the 'X' measure group." error occurs.


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 then 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. Also, when a dimension is deployed then the cube that this dimension relates to is taken offline. If all dimensions are deployed then the result would be that all cubes would be taken offline. Since the cubes would need to be process 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
Have more questions? Submit a request

Comments