4 Replies Latest reply: Jan 17, 2013 8:04 AM by Srini VEERAVALLI RSS

    OBIEE10g: extending a fact table with a custom fact

      Hello everyone!

      I have the following problem: I created a table with, let's say only two fields: primary key COMMISSION_LINE_ID and a measure called PAID.

      After joining my new table with the existing fact table on COMMISSION_LINE_ID both in the physical and logical layer, I tried to set my measure PAID with an aggregation level of SUM. If instead I do not set an aggregation level, everything works fine.

      My goal is to aggregate it but the query always crashes with a message like the following:

      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: 14026] Unable to navigate requested expression:
      Please fix the metadata consistency warnings. (HY000)

      What can I do?

      Thanks in advance for your suggestions!

      Edited by: 911078 on 17-gen-2013 3.52