How to Replace Null Values in an OBIEE Pivot Table – Revisited

According to my server logfiles, the previous post on this topic is one of the most popular on this site. In light of that I felt it was time for an update concerning the ability to do the same in OBIEE 11g. It seems that the ability to apply a custom format mask (e.g. #,###0;-#,###0;0) […]

Using Compound Layouts in a View Selector (OBIEE 11g)

It seems that with release 11.1.1.5 of OBIEE that we are able to nest a Compound Layout within a View Selector. This allows the view selector to be used to switch between multiple complex layouts, each comprising multiple views. Previously it was possible to reproduce this effect by hacking the report XML but it’s now […]

OBIEE 11g – Export To The File System

Here’s a nice script I wrote to enable the exporting of content from OBIEE to the Windows file system. Useful if you don’t have enough licences for everyone to consume reports/dashboards within the OBIEE application or if you want to build an archive over time. The principle is quite simple, an Agent is set up […]

OBIEE 11g – Remove Border Around Section Prompt

When splitting a chart or table into sections by dragging a column to the ‘prompts’ area, the default behaviour is for Presentation Services to apply a rather unsightly border around the column. E.g. Doing this: Results in this: It seems there is no application setting to control the look and feel of this border so […]

OBIEE Inline Microcharts using Google Charts API

By using a combination of techniques it is possible to display charts inline, within an OBIEE report. In other words we can achieve this type of ‘sparkline’ trend indicator instead of a plain table. To achieve this we need to make use of Google’s excellent chart API. The following example is a bit of a […]

Displaying External Documents on an OBIEE Dashboard

Recently a client came up with a requirement to host externally-generated PDF reports in OBIEE and have them display alongside their other OBI content. They also wanted these files to be searchable by name like the rest of elements comprising the web catalog. To achieve this requires a few steps and a bit of trickery […]

OBIEE Hide the Refresh link within the No Results view – Revisited

Following on from this earlier post, reader Leigh has been in touch with a good idea to hide the refresh link on the ‘No Results’ page using only CSS to make the containing, html td element hide. It’s cross browser compliant and has been tested on OBIEE 10g and 11gR1. For 10.x you will still […]

OBIEE Dynamic Dashboard Prompts

Sometimes I need to create a dashboard prompt that shows only the most recent x periods. I like to make this dynamic so that the values are not hard-coded and the prompt can survive when new data appears in the warehouse. The best way I have found to acheive this is to create the prompt […]

OBIEE 11g Changing the Default Dashboard

A common question I come across is how do we set the default homepage in OBIEE 11g? I.e. How do we change the first dashboard that the user sees when they log in? Essentially the approach is the same as in previous versions but for those of you who don’t know, here are the basic […]