Attribute DimensionsMember attributes are not automatically associated to corresponding dimensions and levels during the import process. To manually create the association, map the member attribute to the appropriate Logical Table in the Business Model Layer Include the attribute in the appropriate Presentation Table in the Presentation Layer
Unbalanced HierarchiesOracle BI EE 10.1.3.3.2 supports unbalanced hierarchies for Essbase sources. The following is an illustration of how unbalanced hierarchies will be represented to end users in the Answers interface.Given a selection of Country, Region when we add “State” to the query. We know that for “Central America,” Regions do not have States.The resulting Answers request is shown in the following image:Note that for the unbalanced branch, for columns below the leaf level, nulls will be displayed.
A descendent member of the expected level is returned
Check that you don't have a hierarchy column side by side with a attribute column
[nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: A descendent member of the expected level is returned. Please check member selection in the report. (HY000)
Documentation / Reference