Just now I received the wonderful error:
Error 15 Errors in the metadata manager. The attribute hierarchy for the Category attribute cannot be created because a hierarchy with the same ID or name already exists.
Gee thanks for the insight there SSAS into what the actual error is. My cube only has one Category dimension, also there is only one hierarchy called Category, which lives, surprisingly in the Category dimension.
As you can imagine the deployment of my cube failed as per below:
And the lovely error below:
It turns out the issue was the the Category Dimension cannot have a hierarchy with the same name as the name of the dimension itself. I.e. you can’t have a hierarchy called ‘Category’ in the ‘Category’ dimension.
Once I changed the name of the hierarchy to ‘Category Group’ the cube deployed and processed as expected.
Gotta love those super descriptive error messages 🙂