OBIEE 11g Query on Essbase Using CustomGroupMembers in MDX Shows No Result By Essbase-methods Like Member.CurrentMember

(Doc ID 1906367.1)

Last updated on FEBRUARY 25, 2016

Applies to:

Hyperion Essbase - Version and later
Oracle Exalytics Software - Version to [Release 1.0]
Information in this document applies to any platform.


When running OBIEE queries against Essbase datasource, and using the Essbase "CustomGroupMember" function, no results are returned for member-functions like "CurrentMember."  For example, the PER_CUSTOM_GROUP_GENERATION_MODE=2 does not return the correct results for a member with CurrentMember formulas. 

If the OBIEE generated SQL is modified to change the solve_order in the query from "SOLVE_ORDER = AGGREGATION_SOLVEORDER" to "SOLVE_ORDER = 100," the query returns the correct results.


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