Oracle Error ORA-37076: (XSMCSESS04) workspace object is not the type of dimension that can have session-only values. Valid types are TEXT, NTEXT, ID, NUMBER, and CONCAT with the UNIQUE attribute.

Oracle Error Message

ORA-37076: (XSMCSESS04) workspace object is not the type of dimension that can have session-only values. Valid types are TEXT, NTEXT, ID, NUMBER, and CONCAT with the UNIQUE attribute.

Reason for the Error

The user tried to add a SESSION value to a dimension type that does not support SESSION values.

Solution

Use a dimension of one of the listed types.