Received this error when attempting to build shared dimensions in Analysis Server cubes & dimensions:
Error string: Detected two sibling members with the same name: GL6 (Level 02).
GL6 was used as a agent description for a customer application. A id was assigned to this entry into the view; however, it seems to be duplicated on the very next entry. My guess is that somehow this information was entered twice.
It is a table that is used as part of a union ... how do I get around this delimma? There is unfortunately not enough documentation that will allow us to go back to the application and delete this agent, so I need to find an alternater route if possible.