Last updated on FEBRUARY 25, 2016
Applies to:Hyperion Essbase - Version 220.127.116.11.003 and later
Oracle Exalytics Software - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 1.0]
Information in this document applies to any platform.
When running OBIEE 126.96.36.199.1 queries against Essbase 188.8.131.52 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
Million Knowledge Articles and hundreds of Community platforms