0 Replies Latest reply: Jan 29, 2013 12:05 AM by 986026 RSS

    Cannot find logical table source coverage for logical columns: OPR4ONWY:U9I


      I am new in OBIEE, I have created a new table in existing OBI subject area , joined it with existing dim table in BMM Layer and place it in physical layer in existing subject area.

      After loading rpd on server when i create new analysis and want to take a result, it gives following error:

      Odbc driver returned an error (SQLExecDirectW).
      Error Details
      Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14070] Cannot find logical table source coverage for logical columns: [ACCOUNTING_DATE]. Please check more detailed level keys are mapped correctly. (HY000)

      SQL Issued: SELECT 0 s_0, "AP Details"."Financials - AP"."ACCOUNTING_DATE" s_1, "AP Details"."Financials - AP"."AMOUNT_PAID" s_2, "AP Details"."Financials - AP"."BASE_AMOUNT" s_3, "AP Details"."Financials - AP"."CANCELLED_DATE" s_4, "AP Details"."Financials - AP"."CHECK_AMOUNT" s_5, "AP Details"."Financials - AP"."CHECK_CURRENCY_CODE" s_6, "AP Details"."Financials - AP"."CHECK_DATE" s_7, "AP Details"."Financials - AP"."CHECK_NUMBER" s_8, "AP Details"."Financials - AP"."GL_DATE" s_9, "AP Details"."Financials - AP"."INV_DIST_BASE_AMOUNT" s_10, "AP Details"."Financials - AP"."INVOICE_AMOUNT" s_11, "AP Details"."Financials - AP"."INVOICE_CREATION_DATE" s_12, "AP Details"."Financials - AP"."INVOICE_CURRENCY_CODE" s_13, "AP Details"."Financials - AP"."INVOICE_DATE" s_14, "AP Details"."Financials - AP"."INVOICE_DESCRIPTION" s_15, "AP Details"."Financials - AP"."INVOICE_DISTRIBUTION_AMOUNT" s_16, "AP Details"."Financials - AP"."INVOICE_NUMBER" s_17, "AP Details"."Financials - AP"."INVOICE_RCVD_DATE" s_18, "AP Details"."Financials - AP"."INVOICE_VOUCHER_NO" s_19, "AP Details"."Financials - AP"."LINE_AMOUNT" s_20, "AP Details"."Financials - AP"."LINE_TYPE_LOOKUP_CODE" s_21, "AP Details"."Financials - AP"."MATCHING_DATE" s_22, "AP Details"."Financials - AP"."PAY_GROUP" s_23, "AP Details"."Financials - AP"."PAYMENT_VOUCHER_NUMBER" s_24, "AP Details"."Financials - AP"."SEGMENT2" s_25, "AP Details"."Financials - AP"."SEGMENT3" s_26, "AP Details"."Financials - AP"."SEGMENT4" s_27, "AP Details"."Financials - AP"."STATUS_LOOKUP_CODE" s_28, "AP Details"."Financials - AP"."VENDOR_NAME" s_29, "AP Details"."Financials - AP"."VENDOR_TYPE" s_30 FROM "AP Details" WHERE ("Financials - AP"."GL_DATE" > timestamp '2012-12-30 00:00:00')

      Can anyone please help me?