My Oracle Support Banner

Exalytics and EPM FR - Reports Fail with "Essbase Error (1007090): Unknown Member Name [null] In Outline Query] ... Cannot Find Dimension ..." (Doc ID 2129925.1)

Last updated on FEBRUARY 03, 2020

Applies to:

Oracle Exalytics Software - Version and later
Hyperion BI+ - Version and later
Information in this document applies to any platform.


When using Oracle EPM Financial Reports (FR) 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].

Followed by:

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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.