OBIEE - Essbase

Obi Edition

Cube scope: :::The refresh interval should be set appropriately to reflect anticipated update cycles for Essbase variables.
Attribute Dimensions
Member 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 Hierarchies
Oracle BI EE 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:Obiee Essbase Unbalanced HierarchyNote that for the unbalanced branch, for columns below the leaf level, nulls will be displayed.
A descendent member of the expected level is returned
[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)

Check that you don't have a hierarchy column side by side with a attribute column
Documentation / Reference

Discover More
Bi Server Architecture With Client
OBIEE - Data Source (Oracle Analytics Adapter)

Oracle BI Server has an extensible and open connectivity layer with a set of adapters that are responsible for communicating with source data servers. An Oracle Analytics Adapter is a dynamically loaded...
Privilege Evaluate Predicate
OBIEE - Evaluate - Embedded DB Functions

This Evaluate functions (since version enables users and administrators to create more powerful reports by directly calling Database functions from: either Oracle BI Answers or by using...
Obiee11g Time Dimension Property
OBIEE 10G/11G - How to set up the time dimension (for time series functions Ago, Todate, ) ?

Oracle BI Server ships Time Series Conversion Functions : AGO and TODATE. They are supported for all relational database and for use with Essbase. They are not support for flat files. To use them on...

Share this page:
Follow us:
Task Runner