Oracle Error ORA-36268: (XSCGMDLAGG01) ‘string’ is not a valid dimension value.

Oracle Error Message

ORA-36268: (XSCGMDLAGG01) ‘string’ is not a valid dimension value.

Reason for the Error

The AGGREGATION parameter list included a value that does not exist in the MODEL dimension that contains the target of the AGGREGATION

Solution

Specify only values from the appropriate MODEL dimension