In this post, you’ll learn more about the Oracle ErrorXOQ-01306: cannot generate cursor manager for MdmValueHierarchy with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
XOQ-01306: cannot generate cursor manager for MdmValueHierarchy
Reason for the Error XOQ-01306: cannot generate cursor manager for MdmValueHierarchy
Cause: A cursor manager could not be created on a query containing an MdmValueHierarchy, because the hierarchy had no LevelExpressions and was not compiled in an analytic workspace.
How to fix the Error XOQ-01306: cannot generate cursor manager for MdmValueHierarchy ?
You can fix this error in Oracle by following the below steps
Action: Either add LevelExpressions to the SolvedValueHierarchyMap of the MdmValueHierarchy, or create a AWPrimaryDimensionOrganization on the hierarchy’s MdmPrimaryDimension. Build the dimension using a COMPILE command.