Oracle Solution for Error ora-36222

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

What triggered 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.

What should we do to fix it:

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