SSAS – Attribute cannot be created because a hierarchy with the same ID or name already exists

Standard

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.

CategoryDimension

As you can imagine the deployment of my cube failed as per below:

DeploymentFailed

And the lovely error below:

Errors_CategoryId

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 🙂

Advertisements

4 thoughts on “SSAS – Attribute cannot be created because a hierarchy with the same ID or name already exists

  1. Steve Young

    You also cannot name a hierarchy the same as another attribute in the dimension. Thanks for your write up, helped me figure that out.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s