aggregates - Rittman Mead

Testing aggregate navigation on OBIEE and Exalytics

One of OBIEE’s many great strengths is aggregate navigation; the ability to choose from a list of possible tables the one which will probably give the optimal performance for a given user query. Users are blissfully unaware of which particular table their query is being satisfied from, since aggregate

Technical

Incremental refresh of Exalytics aggregates using native BI Server capabilities

One of the key design features of the Exalytics In-Memory Machine [http://www.oracle.com/uk/solutions/ent-performance-bi/business-intelligence/exalytics-bi-machine/overview/index.html] is the use of aggregates (pre-calculated summary data), held in the TimesTen In-Memory database. Out of the box (“OotB”) these aggregates are built through the OBIEE tool,

Technical

Incremental refresh of Exalytics Aggregates using TimesTen

Introduction One of the key reasons that Exalytics can deliver sub-second response times is the use of TimesTen in-memory database to hold data pre-calculated to various levels of aggregation as required by the reports. Last year I wrote about Alternatives to the Summary Advisor [http://www.rittmanmead.com/blog/2012/