Referential Integrity error when deleting Entity member in BPC 10.1 NW

[oma_chooraman]

Hello, I'm trying to delete members that are no longer used in an Entity dimension. I'm encountering this error message when I attempt to delete:

"Member xxxxxxx. Deletion is not allowed in order to maintain referential integrity.
This member is used as a reference for a property value.
The member will be restored frpom the list of recently deleted members."

The affected dimension uses the CURRENCY dimension , and is used by an INTCO dimension for Referential Integrity. Has anyone encountered this, and if so, how did you resolve it. We're using 10.1 SP11 on NW. Standard models.

I appreciate any feedback.

[oma_chooraman · Accepted solution]

Issue resolved - I deleted the properties for the affected members in the entity dimension, and also the properties for the members in the INTCO dimension that reference the entity being deleted. I was then able to delete the entity members.

[former_member186338 · Accepted solution]

Then please close the question

[former_member186338]

Have you corrected properties in INTCO dimension and currency?

Please provide screenshots...

[oma_chooraman]

Screenshot of the Entity dimension showing CURRENCY is used for Referential Integrity:

And screenshot of the INTCO dimension showing that the Entity dimension above is used for Referential Integrity:

Thanks.

[former_member186338]

I am talking about screenshots of member lists, not about dimension structure (more or less standard in your case).

Do you have members in INTCO with entity property value equal to entity member I'd you want to delete?