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.

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.

Oracle BI - Localization - Translate Web Catalog Objects (Part 2)

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.

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.

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.

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.

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.