How to fix the Oracle error ORA-36280: (XSCGMDLAGG08) Valueset workspace object does not contain values of any dimension of the current model.?

In this post, you’ll learn more about the Oracle ErrorORA-36280: (XSCGMDLAGG08) Valueset workspace object does not contain values of any dimension of the current model. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36280: (XSCGMDLAGG08) Valueset workspace object does not contain values of any dimension of the current model.

Reason for the Error ORA-36280: (XSCGMDLAGG08) Valueset workspace object does not contain values of any dimension of the current model.

AGGREGATION specified a valueset of a dimension not listed in a DIMENSION statement for the current model.

How to fix the Error ORA-36280: (XSCGMDLAGG08) Valueset workspace object does not contain values of any dimension of the current model. ?

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

Add the valueset’s dimension to the model’s DIMENSION list, or choose a different valueset.