5 Replies Latest reply on Aug 5, 2010 6:13 AM by kart

    OBIEE Answers - View Display Error


      I am trying to create a report in OBIEE using some dimensions and fact measures. I select the criteria and display results, I get the following error message:

      Odbc driver returned an error (SQLExecDirectW).
      Error Details
      Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
      State: HY000. Code: 0. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)
      SQL Issued: SELECT Time."Month Name" saw_0, "Workflow Fact"."Total Case Handlers" saw_1 FROM "HCBF Applications" ORDER BY saw_0

      Can anybody help how to resolve this. The items exist in the presentation layer and keys have been defined from dimensions -> fact.