Oracle Business Intelligence

On a recent project, there was a lot trouble getting BI Publisher setup correctly under OBIEE.  We had the following error when trying to login to BI Publisher:
[nQSError: 43001] Authentication failed for ADMINISTRATOR in repository Star: invalid user/password.

.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem [...]

December 4th, 2008 | Category: BI Publisher, Business Intelligence, OBIEE | Leave a comment

On my previous project, we had been facing a very strange LDAP-related issue for a while, which prevented us from upgrading to OBIEE 10.1.3.4.  The problem was that upon doing an install of 10.1.3.4, users who accessed the server using an LDAP account could no longer log in.  Even worse, when someone tried to log [...]

November 19th, 2008 | Category: Business Intelligence, OBIEE | Leave a comment

For those who run their OBIEE servers in a Linux environment, it’s possible to open your repository in Online mode from your Windows-based local machine.  I just discovered this, so I thought I would pass it along.  This assumes that you have the appropriate version of OBIEE installed on your local machine.
Update: Do not use [...]

October 14th, 2008 | Category: Business Intelligence, OBIEE | Comments (1)

This is a bit of a specific problem, but I could see it being something that those new to OBIEE could run into.  It deals with incorrect Grand Total values being displayed for a Calculated Column when using report filters.
Consider the following report:

In this report, Amount A and Amount B are standard columns in a [...]

October 3rd, 2008 | Category: Business Intelligence, OBIEE | Comments (4)

I received the following email this morning:
Attention OBIEE Interested Parties
Oracle University would like your opinion.  They are in the very preliminary stages of scoping out the viability of an OBIEE certification path.  Please click the link below to fill out a short survey. 
http://education.oracle.com/pls/web_prod-plq-dad/ou_online_display_survey.display_survey?p_survey_no=300&p_preview=N

It would seem Oracle University is considering updating the certification path for [...]

September 18th, 2008 | Category: Business Intelligence, OBIEE | Leave a comment

If you’ve read my previous post about Using the Top N Filter, this will be a follow up post that covers a trick I discovered when the Top N filter didn’t do what I wanted it to do.
My requirement is to only show data for the past 6 weeks.  I have a base table that [...]

September 12th, 2008 | Category: OBIEE, SQL | Leave a comment

When working on systems with frequent data loads, the OBIEE cache can often prevent end users from seeing the latest data.  Sometimes it’s appropriate to disable caching on particular tables or reports.  OBIEE has two types of caching mechanisms - Presentation Services caching and individual table caching.
The following link provides a few very good posts [...]

September 5th, 2008 | Category: Business Intelligence, OBIEE | Leave a comment