Oracle Error ORA-36816: (XSTBLFUNC09) The workspace object dimension is of datatype string which does not support custom member upserts.

Oracle Error Message

ORA-36816: (XSTBLFUNC09) The workspace object dimension is of datatype string which does not support custom member upserts.

Reason for the Error

Custom members were attempted to be added via an upsert to a dimension that does not support them

Solution

Disable the AW Hash optimization for this query