Get Informatica Node Name

Posted on June 27, 2012 by Paul McGarrick
Filed Under BI Apps, Informatica, Unix/Linux

Further to my earlier post where I queried the metadata schema to get various Informatica parameters, I thought I would share this quick snippet…

In order to get the Informatica Node name you can run this shell command (Unix):

${INFA_HOME}/isp/bin/ getNodeName | grep -e \n -m 1

Bye for now…

Leave a Comment

Get Informatica 9.x Domain Details from Metadata

Posted on June 14, 2012 by Paul McGarrick
Filed Under BI Apps, Informatica

When setting up Informatica Client tools you might get stuck wondering what settings to use for the Domain and Port number. Presumably you will know the machine host name to use. You can use some sql against the Informatica metadata tables to help you figure out the required settings. E.g. something like this:



Downgrading RPD version in OBIEE 11g

Posted on June 13, 2012 by Paul McGarrick
Filed Under 11g Repository, Admin Tool, OBIEE 11g

OBIEE Administration ToolToday I encountered a problem when trying to deploy a later version repository into an earlier environment. In this case my changes were made in the Administration Tool (v 318) and I needed to deploy the RPD to an environment (v 308). Without downgrading the repository I was not able to start the BI Server component. Here’s how I got around it…

First I ran nqudmlgen.exe from the later ( environment. This can be found in <BI_HOME>\bifoundation\server\bin

nqudmlgen.exe -N -P Admin123 -R C:\RPD\11116.rpd -O C:\RPD\udml.txt

Then I edited the file in a text editor to remove any instances of these lines:


Finally I used nqudmlexec.exe that comes with the earlier ( environment and is bundled with the Client Tools installation.

nqudmlexec.exe -P Admin123 -I C:\RPD\udml.txt -O C:\RPD\11115.rpd

My new RPD could then be deployed via EM with no major complaints besides a few warnings in the nqserver.log file.


Sharing MDS Schema During OBIEE Install

Posted on June 8, 2012 by Paul McGarrick
Filed Under Installation, OBIEE 11g, RCU

It seems we can reuse an existing MDS schema when running the Repository Creation Utility (RCU). Previously I’d always created a new one for each installation but I guess I should have paid more attention to the Oracle documentation…

If your organization has an MDS schema installed in a supported database, you do not need to install the MDS schema again with RCU. You can use the existing MDS schema for your Oracle Business Intelligence installation. For this option, deselect the Metadata Services schema in the Select Components screen of RCU. Then, when you install Oracle Business Intelligence, specify the details for the existing MDS schema in the MDS Schema screen.

You always need to create one BIPLATORM schema for each instance you install – it’s only the MDS schema that can be shared. More info here.

I hope this helps you keep things neat and tidy – should save a few Mb in the database too!


I’m still here!

Posted on June 7, 2012 by Paul McGarrick
Filed Under Total-BI

Recently I haven’t been posting here as much as I’d like, mainly because I’ve been working hard as a Team Leader at the end of a monster commute. Getting home late and tired each evening left me with little appetite to update the blog. The good news is I’ve now moved on from that role so should be able to update this site like the good ol’ days.

Watch this space for more posts coming soon…

Leave a Comment

OBIEE Released

Posted on February 21, 2012 by Paul McGarrick
Filed Under Installation, OBIEE 11g

Oracle have put the latest version of OBIEE – – up for download via their Software Delivery Cloud (formerly eDelivery). No doubt it will be on general download via OTN in the near future.

I’m looking forward to trying this out and for the various bug fixes that we’ve had to work around in the previous versions of 11g.

1 Comment

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

Posted on January 26, 2012 by Paul McGarrick
Filed Under Answers, Dashboards, OBIEE 11g, Pivot Table

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) to a column and have it apply to a pivot table view is broken in version Oracle have confirmed this is an unpublished bug (13054445) so we are stuck with it for the time being until comes along.

Leave a Comment

OBIEE 11g Dimension Browse Revisited

Posted on January 24, 2012 by Paul McGarrick
Filed Under Admin Tool, LTS, OBIEE 11g

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

It seems this feature never really worked properly and you could click it, click ok, come back to the dialog later and it would be unticked again.

Oracle are now saying that this feature is obsolete and has been replaced by a better way of handling dimension-only queries. It seems the checkbox is hanging around in the UI without doing anything! Maybe it will be gone when comes along?

More info on the Oracle Support site if you really need it: Doc Id 1394335.1 and Bug reference 13341484.

Leave a Comment

Help, our users can’t log in!

Posted on January 12, 2012 by Paul McGarrick
Filed Under Active Directory, LDAP, OBIEE 11g

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.

After being assured that none of the LDAP configuration had been changed in Weblogic Console we figured it must be something external, within AD itself.

A bit of poking around with Softerra LDAP browser pinpointed the cause: the IT Support department had ‘helpfully’ moved the equivalent of the BISystemUser account to a different Base DN so it no longer sat alongside the rest of the users. This is a big no-no as it must be in the same place as the rest of the users because we can only specify one Base DN within Weblogic. After moving the user back to the correct place, connectivity was immediately restored and the problem went away.

The IT Support dept were suitably chastised and now everyone is happy again.

Leave a Comment

OBIEE London Social Meet Update

Posted on November 4, 2011 by Paul McGarrick
Filed Under Social

Just a quick post to say that it’s not too late to express an interest in the OBIEE social gathering next Thursday, 10th November. Some space has been reserved from 6pm upstairs at the Craft Beer Bar, near Chancery Lane and Faringdon tube stations. All working in the field are welcome. Please get in touch if you plan on coming so we have an idea of numbers.

1 Comment

« go backkeep looking »