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?