How to fix the Oracle error XOQ-01936: invalid partition dimension for SPARSE_GLOBAL cube?

In this post, you’ll learn more about the Oracle ErrorXOQ-01936: invalid partition dimension for SPARSE_GLOBAL cube with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

XOQ-01936: invalid partition dimension for SPARSE_GLOBAL cube

Reason for the Error XOQ-01936: invalid partition dimension for SPARSE_GLOBAL cube

Cause: SPARSE_GLOBAL cube cannot have a sparse partition dimension.

How to fix the Error XOQ-01936: invalid partition dimension for SPARSE_GLOBAL cube ?

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

Action: Change the definition of the cube.