In this post, you’ll learn more about the Oracle ErrorXOQ-01303: incorrect cube dimensionality with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
XOQ-01303: incorrect cube dimensionality
Reason for the Error XOQ-01303: incorrect cube dimensionality
Cause: The metadata that defines the dimensionality of a cube was incorrect.
How to fix the Error XOQ-01303: incorrect cube dimensionality ?
You can fix this error in Oracle by following the below steps
Action: Check the metadata for the dimensionality of the cubes being queried. Ensure that the number of join columns on the fact table matches the number of join columns on the dimension table.