Using the ELK Stack to Analyse Donor’s Choose Data

Saturday, April 25th, 2015 by

Donor’s Choose is an online charity in America through which teachers can post details of projects that need funding and donors can give money towards them. The data from the charity since it began in 2000 is available to download freely here in several CSV datasets. In this article I’m going to show how to use the ELK stack […]

BI Forum 2015 Preview — OBIEE Regression Testing, and Data Discovery with the ELK stack

Friday, April 24th, 2015 by

I’m pleased to be presenting at both of the Rittman Mead BI Forums this year; in Brighton it’ll be my fourth time, whilst Atlanta will be my first, and my first trip to the city too. I’ve heard great things about the food, and I’m sure the forum content is going to be awesome too […]

Analysing ODI performance with Flame Graphs

Thursday, April 2nd, 2015 by

Flame Graphs are a visualisation that I learnt about through the excellent Linux systems performance work of Brendan Gregg, and saw Luca Canali talk about recently at UKOUG Tech 14. They’re a brilliant way of summarising extremely dense information in a way from which the main components accounting for the most time can be identified. […]

Lifting the Lid on OBIEE Internals with Linux Diagnostics Tools

Friday, March 27th, 2015 by

There comes the point in any sufficiently complex or difficult problem diagnosis that the log files in OBIEE alone are not sufficient for building up a complete picture of what’s going on. Even with the debug/trace data that Presentation Services and other components can be configured precisely to write you’re sometimes just left having to […]

OBIEE nqcmd Tidbits

Tuesday, March 24th, 2015 by

nqcmd is the ODBC command line tool that always has, and hopefully always will, shipped with OBIEE. It enables you to manually fire queries directly at the BI Server, rather than through the usual way of Presentation Services generating Logical SQL and sending it to BI Server. This can be useful in several cases: Automated […]

Website Design & Build: tymedia.co.uk