How to fix the Oracle error XOQ-01744: The LOAD PRUNE command cannot be used with cube “string”.?

In this post, you’ll learn more about the Oracle ErrorXOQ-01744: The LOAD PRUNE command cannot be used with cube “string”. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

XOQ-01744: The LOAD PRUNE command cannot be used with cube “string”.

Reason for the Error XOQ-01744: The LOAD PRUNE command cannot be used with cube “string”.

Cause: A build specification contained a LOAD PRUNE command for a cube that did not support the PRUNE option. To be compatible with the LOAD PRUNE command, a cube must have exactly one CubeMap; the CubeMap must contain a CubeDimensionalityMap for the partition dimension; the CubeDimensionalityMap for the partition dimension must specify a MappedDimension; and the MappedDimension object must contain a DimensionMap.

How to fix the Error XOQ-01744: The LOAD PRUNE command cannot be used with cube “string”. ?

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

Action: Remove the PRUNE option from the LOAD command.