OBIEE performance - get your database sweating

Just because something produces the correct numbers on the report, it doesn’t mean you can stop there. How you are producing those numbers …

OBIEE Systems Management - dodgy counter behaviour

Over the last few months I’ve been doing a lot of exploring of OBIEE Systems Management data, covered in a mini-series of blog posts, Collecting …

Changing LDAP settings in an OBIEE RPD with UDML

A chap called Kevin posted a comment on a previous posting of mine asking did you ever come across anything that could be used to change the LDAP …

Instrumenting OBIEE for tracing Oracle DB calls

Cary Millsap recently published a paper “Mastering Performance with Extended SQL Trace” describing how to use Oracle trace to assist with …

Adding OBIEE monitoring graphs into OAS

Introduction This is the third part of three detailed articles making up a mini-series about OBIEE monitoring. It demonstrates how to capture OBIEE …

Charting OBIEE performance data with gnuplot

Introduction This is the second part of three detailed articles making up a mini-series about OBIEE monitoring. It demonstrates how to capture OBIEE …

Collecting OBIEE systems management data with jmx

Introduction This is the first part of three detailed articles making up a mini-series about OBIEE monitoring. It demonstrates how to capture OBIEE …

OBIEE monitoring

Those of you who read my blog regularly may have noticed I have a slight obsession with the OBIEE systems management capability which is exposed …

OBIEE 10g - javahost hang

Hot on the heels of one problem, another has just reared its head. Users started reporting an error with reports that included charts: [sourcecode] …

Troubleshooting OBIEE - LDAP (ADSI) authentication

They say about travelling that it’s the journey and not the destination, and the same is true with this problem we hit during a deployment to …

A Poor Man’s OBIEE EM/BI Management Pack

Folk from Yorkshire are tight, so the stereotype goes. So here’s a cheap-ass way to monitor OBIEE 10g using nothing but the OBIEE built-in …

Two excellent OBI presentations from Jeff McQuigg

Jeff McQuigg has posted two presentations that he gave at Openworld 2010 on his website here: http://greatobi.wordpress.com/2010/10/26/oow-presos/ …

awk - split a fixed width file into separate files named on content

More of a unix thing than DW/BI this post, but I have a beard so am semi-qualified…. The requirement was to improve the performance of some ODI …

RTFM? But where TF is the FM? >> Offline searchable OBIEE 11g documentation

I’m a geek. I like understanding things in their absolute entirety. It frustrates me to have to make presumptions or assumptions about …

Measuring real user response times for OBIEE

@alexgorbachev tweeted me recently after picking up my presentation on Performance Testing and OBIEE. His question got me thinking, and as ever the …

Scripts to extract information from OBIEE NQQuery.log

Here are a couple of little unix scripts that I wrote whilst developing my performance testing OBIEE method. They’re nothing particularly …

OBIEE 11g launch date - 7th July 2010

OBIEE 11g is going to be officially launched on 7th July (this year!) in London: Launch Event: Introducing Oracle Business Intelligence Enterprise …

Performance Testing and OBIEE

Here’s my presentation “Performance Testing and OBIEE” that I gave at the RittmanMead BI Forum 2010: Performance Testing and …

RittmanMead BI Forum 2010

I’ve just returned from the RittmanMead 2010 BI Forum which this year was at the Seattle Hotel in Brighton Marina. The event was limited to 50 …

Validating EBS-BI authentication, without BI

Troubleshooting EBS-BI integrated authentication can be a tiresome activity, so here’s a shortcut that might help. If you suspect the problem …