Lookup table setup and "No fact table exists" error — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Lookup table setup and "No fact table exists" error

Received Response
51
Views
4
Comments
aPsikus
aPsikus Rank 6 - Analytics Lead

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

  • Joel
    Joel Rank 8 - Analytics Strategist

    Did you see this document from Oracle?

  • aPsikus
    aPsikus Rank 6 - Analytics Lead

    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?
  • Joel
    Joel Rank 8 - Analytics Strategist

    Did you see this document from Oracle?

  • aPsikus
    aPsikus Rank 6 - Analytics Lead

    Well, you have already pasted the same link.

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