Translate

Wednesday 21 December 2011

Shahed

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

Shahed

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

Shahed

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...
Shahed

Presentation Cache Instanceconfig Tags...

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

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...
Shahed

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...
Shahed

Common System Session Variables

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

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/...
Shahed

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="...
Shahed

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...
Shahed

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...
Shahed

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...
Shahed

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...
Shahed

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...
Shahed

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...
Shahed

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...
Shahed

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...
Shahed

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...
Shahed

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 ...
Shahed

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...
Shahed

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...
Shahed

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...
Shahed

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

Shahed
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

Shahed

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

Shahed

OBIA 7.9.6 Advanced Diagnostics

OBIA 7.9.6.2 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

Shahed

Oracle Data Integrator 11.1.1.5 Out Now

Oracle Releases Oracle Data Integrator 11.1.1.5.0 http://www.oracle.com/technetwork/middleware/data-integrator/documentation/index.html#11...
Shahed

OBIEE 11.1.1.5 is Out

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

Thursday 24 February 2011

Shahed

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

Shahed

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

Shahed

OBIEE 11g Start and Stop Commands

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

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

Shahed

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