ORA-36170: (XSMXAGGR12) The data type of the WEIGHT workspace object must be numeric or BOOLEAN, not string.

ORA-36170: (XSMXAGGR12) The data type of the WEIGHT workspace object must be numeric or BOOLEAN, not string.

Cause: The user specified a WEIGHT variable or formula which wasn t numeric or boolean

Action: Specify a numerical or boolean weight instead