OBIEE 11g Dimension Browse Revisited

I’ve blogged before about the Dimension Browse feature in the OBIEE Admin Tool. For the uninitiated, there is a “Dimension Browse” checkbox within the logical table source (LTS) dialog which appeared with the release of version 11.1.1.3. It seems this feature never really worked properly and you could click it, click ok, come back to […]

Help, our users can’t log in!

I got a call from a previous client yesterday. Their OBIEE system wasn’t allowing anyone to log in and understandably they were looking for a quick resolution. The system in question was set up with authenication against the company’s MS Active Directory via LDAP so that seemed like the most likely place to start looking. […]

nQSError 77005 When Importing Oracle OLAP Cube

I came across an interesting problem today when importing an Oracle OLAP cube using the Administration Tool that comes with the OBIEE 11g Client Tools. The import failed with the error message: [nQSError: 77005] An invalid parameter was passed to the nQWebIBotAPI.dll. Verify that the Agent configuration is correct. When you install the client tools […]

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 […]

Patching OBIEE 11g with OPatch

It is a good idea to make sure the PATH environment variable contains the %ORACLE_HOME%\OPatch directory amongst the others. Check if this is the case by running the following command at a new command prompt: opatch version If you see a version number and OPatch succeeded then the PATH variable is set up correctly. If […]

OCM Error when using OPatch with OBIEE 11g

While applying a one-off patch to an OBIEE environment via OPatch it failed with this message: The response file for OCM configuration does not exist (or) is not readable. Please provide a valid response file. In this environment we were not using OCM so it hadn’t been configured. It seems OPatch will create a new […]

OBIEE 11g Transactional Update Failed [nQSError:37005] – Patch Available

I’ve blogged in the past about the annoying Transactional update failed message that is seen when editing the OBIEE 11.x repository in online mode. Well it seems Oracle have finally released a patch to fix this – #9884975. It can be downloaded once you’ve obtained the necessary password via a Service Request.

Adding an XML Data Source in OBIEE 11g

Here’s a quick example of how to manually set up an XML file as a source in OBIEE 11g. First I created a simple example file named XML_Example.xml. Here is the structure: Download it here if you want to try it out and are too lazy to type. Next, create a new database in the […]

OBIEE 11g Usage Tracking RPD

It seems a lot of people are having problems implementing Usage Tracking in OBIEE 11g. The sample repository RPD file supplied by Oracle as part of the 11.1.x install is from the older (10g) version and requires uplifting via the upgrade assistant. Unfortunately the upgrade assistant requires that the repository has a password specified and […]

OBIEE 11g – Deploying Custom Skins, Styles etc.

It’s been posted on the web before but I always struggle to find the link to this useful Oracle White Paper. It describes the steps required to customise the OBIEE user interface. To save you searching, here’s the link: White Paper on OTN There’s also a new tutorial from Oracle on this subject. See the […]

« go backkeep looking »