Orphaned dimension value after reference table entry deletion

Resolved

Hello,

When a reference table entry used as a dimension value on a right is deleted, the role assignments referencing it retain only the raw ID — the value can no longer be resolved.

A few questions:

  1. Is this the expected behavior? Is there a native mechanism to handle this case?

  2. What is the recommended way to fix orphaned values in bulk?

  3. Is it possible to configure a fallback/default value on a right dimension for such cases?

Role model
1 reply