Oracle Error ORA-34061: (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions.

Oracle Error Message

ORA-34061: (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions.

Reason for the Error

Only UNIQUE concat dimensions can have custom member values.

Solution

Use the CHGDFN command to change the concat dimension to UNIQUE and retry.