Oracle Error ORA-34260: (MXDCL25) You cannot use number to dimension a string because it is, or involves, a dimension composite. Use the composite’s bases instead.

Oracle Error Message

ORA-34260: (MXDCL25) You cannot use number to dimension a string because it is, or involves, a dimension composite. Use the composite’s bases instead.

Reason for the Error

The user attempted to use a COMPOSITE in the dimension list of an object that does not allow for such dimensions.

Solution

Use the base dimensions of the COMPOSITE in the dimension list.