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 ...
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...
Monday, 14 November 2011
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 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
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...
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
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 boot.properties 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...
