Hi,
I have a DMR (DQM) Package having one of the dimension Teaching Hospital. The Hierarchy contains Teaching Hospital name as Member Caption & Teaching Hospital ID as Business Key and associated Fact Table "Payment" having a Query Item "Payment in USD" .
The Hierarchy First Data Load the report is running fine. For the second data load the Teaching Hospital ID's were updated.
But the report shows the below error when the report is run after the second data load. Can you please let me know why this happens.
XQE-PLN-0298
Member already exists in hierarchy '[Business View].[Teaching Hospital].[Teaching Hospital]', with member unique name '[Business View].[Teaching Hospital].[Teaching Hospital].[Teaching Hospital]->[1842]' having caption: 'MORRISTOWN MEMORIAL HOSPITAL'. Cannot add the same member with caption: 'MORRIS TOWN MEMORIAL HOSPITAL'. This is most likely caused by a DMR model where a given member unique name cannot be associated with a unique _memberCaption. Such can happen when a _businessKey is incorrectly chosen or when _businessKey and _memberCaption are defined using macro expressions that evaluate to different values for the same member unique name.
You've got a non-unique member unique name. The business key that you're trying to use is not unique.
The second problem is that you're using something which is volatile as the keys for your members.