Saturday, November 22, 2008

OBIEE Excel count distinct error

I have a simple Excel sheet imported into OBIEE:

image

If I do a count it works fine:

image

But if I do a count distinct I get an error:

image

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:

image

Now it works perfect:

image

Till next time

2 comments:

Myea Amelia said...

Thanks for the examples

alex said...

good good. thanks a lot!!!