Lookup table setup and "No fact table exists" error

Question

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?

aPsikus · Answer

Well, you have already pasted the same link.

And yes, I have repeated same setup. Error as in previous post.

Joel Acha · Answer

Did you see this document from Oracle?

aPsikus · Answer

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?