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 11.1.2.3.003 and later
Oracle Exalytics Software - Version 1.0.0.4.0 to 1.0.0.4.0 [Release 1.0]
Information in this document applies to any platform.

Symptoms

When running OBIEE 11.1.1.7.1 queries against Essbase 11.1.2.3 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.

Cause

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