Testing aggregate navigation on OBIEE and Exalytics

Saturday, May 18th, 2013 by

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 navigation happens on the BI Server […]

Incremental refresh of Exalytics aggregates using native BI Server capabilities

Monday, April 8th, 2013 by

One of the key design features of the Exalytics In-Memory Machine 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, and when the underlying data changes they must be rebuilt from scratch. For OBIEE (Exalytics or not) […]

Incremental refresh of Exalytics Aggregates using TimesTen

Thursday, January 10th, 2013 by

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 when considering how to build and maintain these aggregates in TimesTen […]

Website Design & Build: tymedia.co.uk