Oracle Solution for Error ora-36816

ORA-36816: (XSTBLFUNC09) The workspace object

dimension is of datatype string which does not support custom member upserts.

What triggered the Error:

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

What should we do to fix it:

Disable the AW Hash optimization for this query