I have a simple Excel sheet imported into OBIEE:
If I do a count it works fine:
But if I do a count distinct I get an error:
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 16001] ODBC error state: 37000 code: -3100 message: [Microsoft][ODBC Excel Driver] Syntax error (missing operator) in query expression 'count(distinct T2207.[F_LETTER])'.. [nQSError: 16014] SQL statement preparation failed. (HY000)
This is causes by the fact that Microsoft Excel doesn't know the "COUNT DISTINCT" command.
You can fix this by deselecting the count distinct feature in the database properties:
Now it works perfect:
Till next time
2 comments:
Thanks for the examples
good good. thanks a lot!!!
Post a Comment