Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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