OBIEE 11G - Aggregate At Function


The aggregate at function permits to aggregate one measure on an other grain that the query.

It has the same effect that a level-based measure configuration but from a logical sql point of view and not from the repository.


ORA-03113: end-of-file on communication channel

You may get this error:

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: 17001] Oracle Error code: 3113, message: ORA-03113: end-of-file on communication channel 
Process ID: 22013 Session ID: 152 Serial number: 46332 at OCI call OCIStmtExecute: WITH SACOMMON1293645

Uncheck the use of the WITH clause in the database features parameters.

Documentation / Reference

Powered by ComboStrap