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/infacmd.sh 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:

SELECT
RINF.PCSF_DOMAIN DOMAIN,
RINF.REPOSITORY_NAME,
NVL(RINF.PORTNUM,655) PORT
FROM
OPB_REPOSIT R,
OPB_REPOSIT_INFO RINF
WHERE
R.REPOSIT_NAME = RINF.REPOSITORY_NAME
AND R.RECID = 1 ;

2 Comments


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 11.1.1.6 Administration Tool (v 318) and I needed to deploy the RPD to an 11.1.1.5 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 (11.1.1.6) 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:

'COMPRESS_COLUMNS' = 'No',
'ROWNUM_LIMIT_SUPPORTED' = 'Yes',
'ROWNUM_OFFSET_SUPPORTED' = 'Yes',
'NUMERIC_SUPPORTED' = 'No',
'ANCESTOR_DIMENSION_PROPERTY_SUPPORTED' = 'No',

Finally I used nqudmlexec.exe that comes with the earlier (11.1.1.5) 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.

4 Comments


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!

2 Comments


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 11.1.1.6 Released

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

Oracle have put the latest version of OBIEE – 11.1.1.6 – 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 11.1.1.5. Oracle have confirmed this is an unpublished bug (13054445) so we are stuck with it for the time being until 11.1.1.7.0 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 11.1.1.3.

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 11.1.1.6 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 »