In this post, you’ll learn more about the Oracle ErrorXOQ-01736: Cube “string” cannot be aggregated because it is compressed. with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
XOQ-01736: Cube “string” cannot be aggregated because it is compressed.
Reason for the Error XOQ-01736: Cube “string” cannot be aggregated because it is compressed.
Cause: An attempt was made to run a nonconsistent solve aggregation on a compressed cube. This is not supported.
How to fix the Error XOQ-01736: Cube “string” cannot be aggregated because it is compressed. ?
You can fix this error in Oracle by following the below steps
Action: Redefine the cube to be noncompressed or do not attempt to run the aggregation.