Oracle Solution for Error ora-33218

ORA-33218: (CINSERT04) %K is not a valid value for the workspace object

dimension. Values for this dimension can have at most number

significant digits after rounding to number

decimal places.

What triggered the Error:

The user attempted to insert a value that had too many digits into a NUMBER dimension. For instance, the user might have tried to insert the value 99999 (5 digits) into a dimension with data type NUMBER(4).

What should we do to fix it:

Use a smaller number for the dimension value, or define a new dimension with a larger precision and replace the old dimension with the new one.