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 ...
Translate
Wednesday, 21 December 2011
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...
