OBIEE 11G - Aggregate At Function

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs) > OBIEE - Logical Sql

1 - About

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.

Advertising

3 - Support

3.1 - 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.

4 - Documentation / Reference