Category Archives: Errors

Fixing “A REPORT totalling function must be in a leaf query block. (HY000)” error in obiee

Standard

Hello Everybody,

today one question (http://forums.oracle.com/forums/thread.jspa?threadID=941347) in OTN, how to fix the following error.

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. NQODBC SQL_STATE: HY000 nQSError: 10058 A general error has occurred. nQSError: 42038 A REPORT totalling function must be in a leaf query block. (HY000)

Cause: A Report totalling function, e.g., REPORT_SUM or REPORT_MAX, is included in a non-leaf query block. This is not allowed.

Remedy is: De-select the option Report-Based Total (when applicable) for all grand totals or subtotals you have applied.

This option is available after you click on sigma button.

Thank You.

Advertisements