Unanswered: Analysis Service 2008 error when deploying a cube
When I tried to deploy a cube, it gave me the following error.
Error 11 Errors in the metadata manager. The 'CUSTOMERNUMBER' intermediate granularity attribute of the 'CONTRACT' measure group dimension does not have an attribute hierarchy enabled. 0 0
It seems like the contract measure group is causing the problem and that's a reference relationship. The advertiser dimension has no direct relationship to the Fact_invoice_detail table, but it is connected to contract and then to the Fact_invoice_detail.