Friday, January 22, 2010

Oracle BI - RPD Change Java Tool

Hello World!

This is my first JAVA tool for Oracle BI, so "Hello World!" :)

I had to change RPD very frequently in NQSConfig.INI and restart services. This tool helps people working on OBIEE on Windows system and looking for a shortcut to change RPD and restart services on just one click or one line of command.

Thursday, January 21, 2010

Oracle BI - Cross Column Conditional Formatting in Pivot Table (workaround)

Pivot table is a great way to analyze a cube of data. Oracle BI supports pivot table, but conditional formatting having condition on the same column works correctly. If  you configure condition which is based on the column other than the one you are formatting conditionally, the conditional formatting will appear in Table view but not in Pivot table view.

Fortunately, I found a workaround for it.

Wednesday, December 16, 2009

Oracle BI - Localization - Translate Metadata Objects (Part 1)

Oracle BI supports dynamic name of a presentation object, which will be retrieved from a session variable.

This feature enables translation of metadata objects into various languages. The topic of translation is referred as different terms i.e.

Localization: Because the objects are displayed in local language.

Globalization: This is seen in Siebel CRM application.
Internationalization: Because, it supports users internationally.


Wednesday, November 25, 2009

Group your measure into a Dynamic Range - OBIEE

This was one of the interview questions, asked to me.

Requirement was for a report, where user can see a measure and range in which that attribute is falling. Range had to be dynamic.

Sunday, November 8, 2009

Pass Values to Prompts or Promted Columns

I had come across a question from my friend for passing values to prompts from an interface which is external to OBI.

Thursday, October 1, 2009

Oracle BI - Multiple RPDs on single OBI Server

Loading multiple RPD on a single OBI server is very easy. But there is an extra requirement to access multiple RPDs.

Sunday, September 27, 2009

Multiple OBI Presentation Services on same machine - Windows

Hello Oracle BI practitioners, this is my first blog. I would be happy if I get any +ve or -ve comments.