Oct 11, · One of the new feature of 11g is the AGGREGATE AT function. It uses the hierarchical level to pin the the aggregate. Problem is you can’t select a hierarchy level in the formula editor, so you have to some old school typing: Example: Only month 1 to 6 are xbook.info: John Minkjan. Server Complex Aggregate — Applies the aggregation rule that is determined by the Oracle BI Server (such as the rule that is defined in the Oracle BI repository). The aggregation is performed by the Oracle BI Server, rather than within Presentation Services. In versions of OBIEE prior to 11g you would use the tnsnames of the Oracle client Author: Duffieldc. Aggregate Navigation using Oracle BI Server 01 November on Technical In this example I'm going to show you how to create an aggregate table, register it with the Oracle BI Server, and have Oracle Answers and Dashboard use it to speed up xbook.info: Mark Rittman. One of the new feature of 11g is the AGGREGATE AT function. It uses the hierarchical level to pin the the aggregate. Problem is you can't select. Issue · New Features · OBIEE 11g · OBIEE Developer · OBIEE Security Aggregate functions perform operations on multiple values to create summary results. . When a measure is based on dimensions, and data is dense, the Oracle BI Server optimizes the SQL statements sent to the . xbook.info For the "OTN Appreciation Day" my favourite feature in OBIEE is. the total of a subset of your data, what level to use in the AGGREGATE.