How to fix the Oracle error ORA-36271: (XSCGMDLAGG11) workspace object is not in the dimension list of valueset workspace object.?

In this post, you’ll learn more about the Oracle ErrorORA-36271: (XSCGMDLAGG11) workspace object is not in the dimension list of valueset workspace object. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36271: (XSCGMDLAGG11) workspace object is not in the dimension list of valueset workspace object.

Reason for the Error ORA-36271: (XSCGMDLAGG11) workspace object is not in the dimension list of valueset workspace object.

A QDR dimension was specified that does not appear in the valueset’s dimension list.

How to fix the Error ORA-36271: (XSCGMDLAGG11) workspace object is not in the dimension list of valueset workspace object. ?

You can fix this error in Oracle by following the below steps

Specify only dimensions in the valueset’s dimension list.