OBIEE 11g Presentation Hierarchy Column Errors When Drilling Down with "Error generating view"," Error getting cursor in GenerateHead" and "Error Codes: OAMP2OPY:ACIOA5LN"
Last updated on JANUARY 30, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 188.8.131.52.12 and later
Information in this document applies to any platform.
- When having a Logical Dimension which contains a Ragged Hierarchy (by creating a Level Based Hierarchy for the Logical Dimension and selecting the tick box for Ragged Hierarchy). the Hierarchy is included in the Presentation Layer as a Presentation Hierarchy column.
- The Presentation Hierarchy can be added to an Analysis and shows data at the Total Level.
- However, on interacting with the Hierarchy column, to drill down through the Hierarchy, the following error appears in the Analysis:
Error generating view. Error getting cursor in GenerateHead
Error Codes: OAMP2OPY:ACIOA5LN
Assertion failure: rExistingFieldInfo.getDataType().getStorageType() == rNewFieldInfo.getDataType().getStorageType() at line 406 of project/webtable/tablemetadata.cpp
- There are no calculated columns in the Hierarchy.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms