OBIEE 11.1.1.5: Essbase Error "No dimension is available to project the pseudo measure" (Doc ID 1425294.1)

Last updated on DECEMBER 05, 2013

Applies to:

Business Intelligence Interactive Dashboard - Version 11.1.1.5.0 [1308] to 11.1.1.5.0 [1308] [Release 11g]
Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] to 11.1.1.5.0 [1308] [Release 11g]
Business Intelligence Reporting and Publishing Option - Version 11.1.1.5.0 [1308] to 11.1.1.5.0 [1308] [Release 11g]
Business Intelligence Server Administrator - Version 11.1.1.5.0 [1308] to 11.1.1.5.0 [1308] [Release 11g]
Information in this document applies to any platform.
***Checked for relevance on 05-Dec-2013***

Symptoms

You are getting the below error when trying to build report out of essbase in OBIEE.

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 22069] No dimension is available to project the pseudo measure. (HY000)

Cause

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