Exalytics and EPM FR 220.127.116.11 - Reports Fail with "Essbase Error (1007090): Unknown Member Name [null] In Outline Query] ... Cannot Find Dimension ..."
Last updated on APRIL 25, 2016
Applies to:Oracle Exalytics Software - Version 18.104.22.168.0 and later
Hyperion BI+ - Version 22.214.171.124.000 and later
Information in this document applies to any platform.
When using Oracle EPM Financial Reports (FR) 126.96.36.199 on an Exalytics, Linux server, an error is encountered when opening EPM Workspace -> Explore Financial Reports -> "Balance sheet"
(path /Financial Reports/ACME/Balance Sheet):
Error executing query: Error: Select members failed [Cannot query members by name: Essbase Error (1007090): Unknown member name [null] in outline query].
Cannot find dimension ACME_CURRENCY
This happens for some users, but not all. It happens on all reports and all users have the same permissions. It does not happen for the Admin user.
While this error occurred on an Exalytics server, it may occur on any EPM FR environment and not just those installed on Exalytics.
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