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

Blog Archive



About Authors

Shahed Munir

Krishna Udathu

Shahed and Krishna are Oracle / Big Data Experts