I have an Analysis Services cube in which I have a dimension called Customer. There are different hierarchies of customer.

The dimension although has the key column set to customer id, but shows the name of the customer. There are 2 customers with the same name and I am receiving the following error.

Detected two siblings with the same name

Can someone please let me know what I can do to fix this.

Thanks,
Saj