Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 105 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Lookup table setup and "No fact table exists" error
OBIEE 12.2.1.2.0
I have clob column in database which is too big to display on the report.
I have tried to implement lookup table with ID, and clob and have added to the dimension new logical column with lookup(dense) formula.
RPD is published, but when try to add the column with lookup formula to the report, it returns error: "No fact table exists at the requested level of detail.
I have done setup based on this webpage: Oracle BI Practice: OBIEE 11g Lookup tables
What have I missed?
Answers
-
Did you see this document from Oracle?
0 -
Hi,
I have added sort order and descriptor which were missing.
Now errors are different:
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: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 24806, message: ORA-24806: LOB form mismatch at OCI call OCILobRead2. (HY000)
State: HY000. Code: 17004. [nQSError: 17004] Statement handle allocation error. (HY000)Maybe it is too long? Or problem is that key is varchar?0 -
Did you see this document from Oracle?
0 -
Well, you have already pasted the same link.
And yes, I have repeated same setup. Error as in previous post.
0
