OBIEE 11g: Report Fails with "Unknown Member" When Shared Members Are Used From Essbase Data Source
(Doc ID 2942311.1)
Last updated on MAY 04, 2023
Applies to:
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 and laterInformation in this document applies to any platform.
Symptoms
When an Essbase cube is used as a datasource and there are members with duplicated names (e.g. shared member) in the Essbase , following error may occur when running the report using that shared member :
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 96002. [nQSError: 96002] Essbase Error: Unknown Member [Measures].[Measure Name] used in query (HY000)
Example: In various scenarios, in multiple hierarchy dimension there can be a shared member in one Essbase hierarchy and base member in another Essbase hierarchy
Note: Since there are duplicate member names, In physical layer of the repository you have also unchecked "use qualified name for better performance" in the measure dimension properties as per the suggestion in the Doc ID 1935556.1, still the error occurs
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |