OBIEE 11G - Aggregate At Function

Obiee Ceim


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.

Obiee 11g Aggregate At


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

Discover More
Obiee Logical Column Level Region
OBIEE 10G/11G - Level-Based Measure Calculations

A level-based measure is a column whose values are always calculated to aspecific level of aggregation. The calculation of this measure is independent of the query grain and used always the aggregation...
Obiee 11g Aggregate At
OBIEE 10G/11G - Period to period comparison with the AGO Function

Ago is a time function that calculates the aggregated value from the current time back to a specified time period. This function is useful for comparisons, such as Dollars compared to Dollars a Quarter...
Obiee11g Architecture Functional Component
OBIEE 11G - New Features and changes 11G

Oracle Business Intelligence Enterprise Edition (OBIEE) 11g is the most significant release of OBIEE since 2006. This article contains the significant changes and new features of OBIEE 11g. Oracle...

Share this page:
Follow us:
Task Runner