How to fix the Oracle error ORA-36168: (XSMXAGGR10) COUNTVAR variable workspace object must have the same dimensionality as workspace object?

In this post, you’ll learn more about the Oracle ErrorORA-36168: (XSMXAGGR10) COUNTVAR variable workspace object must have the same dimensionality as workspace object with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36168: (XSMXAGGR10) COUNTVAR variable workspace object must have the same dimensionality as workspace object

Reason for the Error ORA-36168: (XSMXAGGR10) COUNTVAR variable workspace object must have the same dimensionality as workspace object

The user specified a COUNTVAR variable which is missing at least one dimension of the aggregation variable

How to fix the Error ORA-36168: (XSMXAGGR10) COUNTVAR variable workspace object must have the same dimensionality as workspace object ?

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

Specify a COUNTVAR variable which has at least as many base dimensions as the aggregation variable