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) [...]

Upgrading OBIEE to 11.1.1.7

Wednesday, April 3rd, 2013 by

OBIEE 11.1.1.7 was released earlier this week, and brings with it the usual delights and challenges of the Fusion Middleware (FMW) platform. Because OBIEE is part of Fusion Middleware, and because it is made up of OBIEE-specific components (such as the BI Server) and FMW-generic components (such as Web Logic domains), the upgrade documentation isn’t [...]

Performance and OBIEE – Summary and FAQ

Monday, March 18th, 2013 by

This article is the final one in a series about OBIEE and performance. You can find the previous posts here: Introduction Test – Define Test – Design Test – Build Execute Analyse Optimise Summary The key to long term, repeatable, successful performance optimisation of a system is KNOWING where problems lie and then resolving them [...]

Performance and OBIEE – part VII – Optimising OBIEE performance (“Tuning”)

Monday, March 18th, 2013 by

Potato potato? When I first drafted this blog post, I gave it the title “Tuning”, rather than “Optimising”. Tuning is the word used so often in the context of performance, but it can actually be a bit misleading. A system that has fundamental design flaws doesn’t need “tuning” – it needs redesigning. Tuning can end [...]

Website Design & Build: tymedia.co.uk