Skip to Content
avatar image
Former Member

Referential Integrity error when deleting Entity member in BPC 10.1 NW

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    May 10, 2017 at 06:47 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • May 10, 2017 at 05:12 PM

    Have you corrected properties in INTCO dimension and currency?

    Please provide screenshots...

    Add comment
    10|10000 characters needed characters exceeded

    • 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?