OBIEE When Excluding All Columns from Rows, nQSError: 43119 returns for Pivot View that has Evaluate Function

(Doc ID 2198139.1)

Last updated on NOVEMBER 17, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version to [Release 11g]
Information in this document applies to any platform.


On : version

In Analysis, create a simple report and edit one of the columns formula to use EVALUATE function.

Like below:

In the pivot view, when exclude all the Rows columns, below error occurs.

Odbc driver returned an error (SQLExecDirectW).
Error Details
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 42015] Cannot function ship the following expression: EVALUATE. (HY000)

We found similar Bug19599154,
And applied patch 19599154 for BIEE:, But error still occurs.
Patch 19599154 seems not be appropriate for this issue.




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms