Skip to content

Category Archives: Uncategorized

OBIEE 11g Released

There’s been big news in the OBIEE world…Oracle just recently released their latest version of OBIEE, 11g. I know my co-workers and I are pretty excited about it. In the coming weeks I am going to be posting about my experiences using the new software to put together analytic dashboards. I’m looking forward to learning [...]

Hiding columns in a Table View that can be used in the Pivot Table

Yes, the title of this post isn’t the most eloquent of titles, but it serves the purpose. One of my co-workers was having an issue where he wanted to hide a column that was being displayed in a table but wanted to use that column later on in a pivot table. When he would go [...]

Limiting Number of Values Selectable

Recently, I was asked to create a dashboard that emulated another. While I hate trying to mold OBIEE to fit the report design of another dashboard, it did present some unique challenges. One of these was giving the users the ability to select from a list of months, but only allowing them to select 3 [...]

Variable Populated Prompts and Using Saved Views

Recently, one of the developers asked me: “Michael, how do you go about saving a view when one of the prompts on the page contains a variable that populates the initial value (such as date)?” I explained that I hadn’t really given it much thought. I continued on with my work for the day, not [...]

Fun with Presentation Variables

Any OBIEE report developer will tell you that in order to get the most out of the tool, you must know and love working with the various forms of variables available to us. Today, we’re going to talk about a great use for the Presentation Variable that’s available to a user in Answers when editing [...]

Opening dashboards without running a query…

I’ve seen this issue brought up a number of times and often I see developers struggling with how to create a dashboard page that will load all their prompts, allow users to select the prompts and then load the report. I’ve used a few methods in the past to do this, but all of them [...]

We need more traction…

A common misconception in automobile racing is that the limiting factor in how fast a racing car can travel around the track is the amount of horsepower under the hood. While this concept has been pounded into our heads by the millions of car advertisements, the simple truth of the matter is that there is [...]

Displaying Images in Excel Downloads

Recently, a defect came through on our project that said that images that were in a report’s header were not showing up in Excel when the user downloaded the report. The report in question was a customer facing report, so it was imperative that the logo be visible to the client when printed. Without getting [...]

The Power of Social Media

Recently I’ve started to use Twitter again, mostly at the bequest of ORACLENERD, and it’s been pretty good so far. I’ve gotten some good information, excellent help and been introduced to some great folks in the OBIEE community at-large. With Twitter on my mind, before I went out this past Friday night, I decided to [...]

Abstract: Catch All Business Intelligence.NET (a.k.a. Cabi.net)

Abstract: Any career in the IT field is defined by an ever changing landscape of hardware and software. Innovation is changing the face of our industry almost yearly. In this rapidly changing environment, as developers, we’re often faced with challenges that aren’t immediately correctable, and in these cases we’re forced to research and develop new [...]