Oracle Error ORA-35589: (XSRWLD16) Cannot change the parent of an existing dimension member in LOAD RETAIN mode.

Oracle Error Message

ORA-35589: (XSRWLD16) Cannot change the parent of an existing dimension member in LOAD RETAIN mode.

Reason for the Error

An attempt was made to change the parent of an existing dimension member in LOAD RETAIN mode.

Solution

Fix the mapping or use LOAD NOSYNCH mode.