OBIEE 11g Query on Essbase Using CustomGroupMembers in MDX Shows No Result By Essbase-methods Like Member.CurrentMember
Last updated on FEBRUARY 25, 2016
Applies to:Hyperion Essbase - Version 184.108.40.206.003 and later
Oracle Exalytics Software - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 1.0]
Information in this document applies to any platform.
When running OBIEE 22.214.171.124.1 queries against Essbase 126.96.36.199 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