Wednesday, 21 December 2011


OBIEE 11g / 12c Row Settings Table and pivot Instanceconfig.

OBIEE 11g / 12c Row Settings Table and pivot When you have a large number of rows in a report Table or Pivot to be viewed . To ...

Sunday, 11 December 2011


OBIEE Clear Server Cache from Direct Database Request

You can clear the OBIEE Server cache by Running a direct database request from Analysis on the front end. 1. Open the RPD, create a ne...

Friday, 2 December 2011


Dashboard Prompt Expand limit on Drop down values.

Ammend Instanceconfig.xml which is located in the OracleBIData\Web\Config Folder - ENTRIES BELOW NEED ADDING JUST ABOVE </ServerInstanc...

Presentation Cache Instanceconfig Tags...

Presentation Caching tags for instanceconfig.xml - ENTRIES BELOW NEED ADDING JUST ABOVE </ServerInstance> AT END OF FILE. Web Cach...

Unix Zip Catalogues

Unix Commands this command is to zip catalog tar -cvf  CAT.tar /app/obiee/OracleBIData/web/catalog/cataloguecustom Command to unzip c...

Dashboard Menus Custom Java Style

Insert text box onto Dashboard and "Contains HTML Markup" must be ticked. then the following statements can be used independently...

Common System Session Variables

currentTime => @{system.currentTime} system.productVersion => @{system.productVersion} session.locale => @{session.locale} = en-...

Basic HTML Link on Dashboard

Insert a text box onto Dashboard "Contains HTML" Paste a url in as below.. And Done.. <A HREF="res/s_oracle10/myfolder/...

OBIEE Pivot Table insert a word in Top Right Cell

Place static code in Answers Request or Dashboard "Contains HTML" <script  type="text/javascript"  language="...

Dashboard Tab Colours

The script below allows the Tabs on a dashboard to be coloured in differnent colours , Quite cool... Just insert a Textbox into a dashboar...

Dashboard When opening report in New window and Drill back button

When you create a dashboard and you have a drill down report the drill down report opens in the same window. So when you hit the return link...

Dashboard Compare 2 Prompt dates to see if they are the same and show ERROR

The following script enables to compare 2 date prompts on a dashbaord  to tell the user to select a prior Date less than the current Date wa...

Refresh a Dashboard in intervals

Hi you can refresh a dashboard in intervals using the following code Insert a text box onto the Dashboard - "Contains HTML" Pa...

OBIEE Table make a row BOLD with JAVA

The below code allows a row in a table to be in Bold - insert a static text box into an answers request and "Contains HTML" Past...

Dashboard Specific remove Print ICON

The script below enables you to remove the Dashboard print icon for a specific Dashboard as sometimes it gets confusing for users between th...

Default Prompts Button Dashboard

The script below allows a button to be displayed on the dashboard which resets all the dashboard prompts back to the original Default values...

Session Variable set for Report only that is running

THESE ARE SET AT QUERY LEVEL FOR A REPORT OR PROMPT RESULTS ONLY If you want to set session variables for a report that is running  in OBI...

Purge all Cache From Dashboard

Using the Java code below OBIEE BI Server cache can be cleared from Dashboard 1.Insert a Text box into a dashboard  "Contains HTML&qu...

OBIEE Update session variables from Dashboard

To update session variables so that they can be used in rpd querys you must call the NQSSetsessionvalue commands this is normally done from ...

OBIEE Cursor Cache clear from Dashboard Java Script

OBIEE Cursor cache is normally cleared from the Administration - Manage Sessions Screen... Here is a way that a piece of java can be embed...

OBIEE Dates in Descending order from RPD Column

When you have a date column and you want to sort it as Descending when picked in Answers but automatically from rpd. 1. Insert a new colum...

Direct DB Request and Integer Problem on Column Selected

Sometimes when you do a direct database Request especially from Oracle you have problems when a number to obiee is an integer Do the below...

OBIEE Pivot Table nulls to Zeros for empty Rows

When you create a pivot table and you see nulls in the measures part , You want to see 0 or 0.00 instead Just change the data format on th...

Monday, 14 November 2011

Updating GUIDs in OBIEE 11g   Best practice is to update the user GUIDs after changing the directory server used as the data source f...

Monday, 31 October 2011


BI Publisher Config Settings

Configuring Server Properties Overview This chapter covers server configuration settings under the System Maintenance region of the Adm...

Wednesday, 14 September 2011


OBIA 7.9.6 Advanced Diagnostics

OBIA Diagnostics Paper a follow on from the OBIA 7.9.6 Installation guide i shared earlier on in the year Previous Installation G...

Monday, 23 May 2011


Oracle Data Integrator Out Now

Oracle Releases Oracle Data Integrator

OBIEE is Out

Hi All well i have been playing around with OBIEE and its alot better seems to be quite stable and quite a few new features are ava...

Thursday, 24 February 2011


Prompt for All Choices is Null when Prompt variable is called in Text

To get a value of ALL when using a prompt with all choices selected try the below using Java Code. Neat solution... Insert a Text Box and cl...

Wednesday, 12 January 2011


2011 Happy New Year

Deliverbi would like to wish everyone a Happy New Year. We will be releasing lots of new OBIEE 11g upgrade documents this year along with OB...

Monday, 10 January 2011


OBIEE 11g Start and Stop Commands

OBIEE 11g Start and Stop Commands Remember files must exist for weblogic servers so you dont have to hardcode usernames...

OBIEE 11g Linux Bash Profile

OBIEE 11g Linux .bash_profile Sample Linux .BASH Profile File we use for obiee 11g mydrive = your drive path my_location = is also a ...

Sunday, 9 January 2011


BI Publisher JDBC Connection Error

In Bi Publisher when creating a JDBC Connection to an oracle database  please ensure there is a TNS Entry available in the network/admin f...

Blog Archive

About Authors

Shahed Munir

Krishna Udathu

Shahed and Krishna are Oracle / Big Data Experts