Performance Testing/Tuning OBIEE

Recently I’ve been heavily involved with Performance Testing and Tuning a new OBIA system for a client. I thought I’d share some of the interesting reading I’ve come across. I hope to write a more detailed post on the topic in the near future but in the meantime… Lots of good material available from Jeff […]

Images with Relative Path not Exported to PDF

Just a quickie… We ran into an interesting situation today when exporting some dashboard contents to PDF. It seems the PDF conversion mechanism can’t reproduce images when they are referenced with a relative path. The fix was simple: refer to the images using the fmap syntax.

Action Link text is Exported to Excel

On a recent customer project I came across an interesting scenario when trying to export a report to Excel. The report in question contained Action Links (invoking a Browser Script) and when exported, the Action Link text and associated hyperlink appeared as an extra row beneath each data cell. After checking with Oracle Support it […]

Briefing Book Table of Contents Page

Quick tip… You can define the front page of PDF Briefing Books by editing toc-template.rtf found in this directory: <MW_HOME>\instances\instance1\config\OracleBIJavaHostComponent\coreapplication_obijh1 This is useful if you need to apply a company logo or set a corporate font. Sadly there’s no way to apply a header/footer to every subsequent page.

New Oracle BI EE Tutorial

Oracle have added another BI EE tutorial to their Learning Library. This one is based on the latest version (11.1.1.6.2 with BP1) and covers how to create and customise Analyses use them to build Dashboards. This should be useful for anyone new to OBIEE, particularly as an end-user rather than a system administrator. See the […]

Communication error with the OPMN server local port

I ran into an interesting problem the other day when trying to start OBIEE components via OPMN. I kept getting the following message: “Communication error with the OPMN server local port” After a lot of head scratching I figured out that somehow OPMN had been started as root user (this was a Unix system) rather […]

Downgrading RPD version in OBIEE 11g

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

Sharing MDS Schema During OBIEE Install

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

OBIEE 11.1.1.6 Released

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

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

keep looking »