OBIEE 11G - Aggregate At Function

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.

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


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap