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 126.96.36.199.003 and later
Oracle Exalytics Software - Version 188.8.131.52.0 to 184.108.40.206.0 [Release 1.0]
Information in this document applies to any platform.
When running OBIEE 220.127.116.11.1 queries against Essbase 18.104.22.168 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