Oracle Error ORA-36222: (XSLPDSC03) duplicate IGNORE or DENSE information for dimension workspace object

Oracle Error Message

ORA-36222: (XSLPDSC03) duplicate IGNORE or DENSE information for dimension workspace object

Reason for the Error

An IGNORE or DENSE list in a dimension loop descriptor included the dimension twice, included two different valuesets of the dimension, or includes the dimension and a valueset of the dimension.

Solution

Only use the dimension or a valueset of the dimension once in an IGNORE or DENSE list.