Oracle Solution for Error ora-36176

ORA-36176: (XSMXAGGR25) Relation workspace object

must be a one-dimensional self-relation to be used as a weight for AGGREGATE.

What triggered the Error:

The user specified an illegal relation as a weight. The relation might have been multidimensional, not a self-relation, or not a relation over one of the bases of the aggregation variable.

What should we do to fix it:

Specify a valid self relation over one of the bases of the aggregation variable.