Oracle Solution for Error ora-36224

Solution for Oracle Error ORA-36224

ORA-36224: (XSLPDSC05) workspace object

is not a loop dimension

What triggered the Error:

An IGNORE or DENSE list in a dimension loop descriptor referenced a dimension (or a valueset of a dimension) that was not a base dimension of the loop dimension list.

What should we do to fix it:

Remove the dimension or valueset from the IGNORE or DENSE list.