2 Replies Latest reply: Apr 4, 2013 8:16 AM by 1000983 RSS

    Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

    1000983
      Hello,
      I am very new to OBIEE.
      I need to perform a join between 2 tables: Retailers and Salerep. I have performed the required join under BMM section but still i have the following error when displaying results:

      <<Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 14050] Internal Error: could not find level detailed enough for GROUP BY clause: [RETAILERS.RETAILER_NUM, SALESREP.SALESPERSON]. (HY000)
      SQL Issued: SELECT RETAILERS.AGENT_NAME saw_0, RETAILERS.RETAILER_NUM saw_1, RETAILERS.FIELD_REP saw_2, SALESREP.SALESPERSON saw_3 FROM "LOTTO_BI#1" ORDER BY saw_0, saw_1, saw_2, saw_3>>

      Can anyone please help?

      Many Thanks,
      Gunajee.