Tuesday Jul 15, 2014

OBIEE 11.1.1 - In case of Firewalls, OBIEE Scheduler may fails to Restart via OPMN or during BI configuration


If you have Firewall between OBIEE Server and Oracle Database machine, the OBIEE Scheduler component may fails to restart via OPMN or during BI configuration.

The firewall is setup with 'Urgent Flag'. As per firewall documentation, the Urgent Flag cannot be disabled. It is a global setting and would affect all traffic going in and out in organization. So the issue can be resolved by setting DISABLE_OOB=ON in the SQLNET.ora for BI Scheduler.

The firewall is clearing this Urgent Bit in the communication, the message is not transferred from the Scheduler (DB Client) to the Oracle database so by setting DISABLE_OOB=ON the Urgent flag is not sent from Scheduler and the connection works normally.

How-to: On BIServer side only, set DISABLE_OOB=ON in SQLNET.ora file > …/Oracle_BI1/network/admin

Friday Jul 11, 2014

Essbase Outline Rebuilding vs. Migrating After Major Release Upgrade

The Essbase Readme document has been updated to include a change in recommendation with regard to rebuilding versus migrating the Essbase outlines between major release upgrades.  This represents a change in the upgrade process to ensure outlines take advantage of any new structures, features and functionality introduced in the major release.

[Read More]

Monday Jul 07, 2014

OLAP_MAX_CONNECTIONS Property Considerations

The OLAP_MAX_CONNECTIONS property controls the maximum number of connections from Planning to Essbase. The default setting is 10, but the property can be increased to allow for more concurrent Essbase connections. The Hyperion Planning Administrator’s Guide recommends a setting of 20 for 100 users and 100 for 500 users.


[Read More]

Monday Jun 02, 2014

OBIEE 11.1.1 - Tips for In-place Upgrade from to


Use the Test to Production (T2P) / cloning process (movement scripts). For example:
– Clone up the existing environment.
– Move the cloned copy to the new location / host (same version at this point).
– Patch new location / host ( to the level.
– Switch to Production.
[Read More]

Tuesday Apr 22, 2014

Error Connecting to Planning Application from Smartview

When the OU of a user is changed in the external provider, users can potentially have issues connecting to Planning applications from Smartview. However, users can still log into Planning just not Smartview. [Read More]

Monday Mar 24, 2014

BI Web service security client - authentication operations for and

This wlst/python script connects to bi security web service to authenticate a user specified in the "ObieeWebServiceClient.properties" file. In, this calls: getAuthenticatedUserWithLanguageAndProperties operation of the /bisecurity/service web service.

In, this calls authenticate operation of the /bimiddleware/security/service web service.

This returns as part of the xml response the user unique identifier (guid) and other permissions/roles for the user. This is useful when debugging an issue with OBIEE security.

The script has to be run with %ORACLE_HOME%\oracle_common\common\bin\wlst.cmd (sh)

Script is available there: https://blogs.oracle.com/pa/resource/ObieeWebServiceSecurityClient.zip

[Read More]

Thursday Feb 27, 2014

OBIEE 11.1.1 - Advanced Usage of nqcmd command

Following are the useful nqcmd command lines arguments:

a. In your environment set the "export SA_NQCMD_ADVANCED=yes"

b. Following is the description of the nqcmd command line arguments for BIServer (nqsserver) testing:

-d = Datasource.
-u = username.
-p = password.
-s = inputsqlsfile.
-o = outputfile. counters will be in outputfile_Counters.txt.
-td <secs> = timeduration in secs. nqcmd will run until <secs> elapses.
-qsel r = select queries random manner from inputsqlsfile.
-ds <secs> = dump statistics to outputfile_Counters.txt every <secs>.
-T = Timer is on. Otherwise you won’t get correct statistics.
-t <number> = generate users . if you give -t 50, 50 users will be there.
-q = turn off row output - mandatory flag for nqsserver load testing.
-n <number> = used for login test run for <number> iterations.
-w = thinktime (in seconds).

[Read More]

Monday Feb 03, 2014

BI Checks with WLST - Enable debug, login and parse logs - Part 3

This third post continues with the BIEE Security checks using WLST and Python scripting.[Read More]

Friday Jan 31, 2014

OBIEE 11.1.1 - Tuning Guide Whitepaper - update available

New updates have been made to the OBIEE "Best Practices Guide for Infrastructure Tuning" whitepaper. This updated whitepaper is for 11g Release 1 (, and can be downloaded from the My Oracle Support knowledge article: Doc ID 1333049.1

The new revised document contains the following useful new and/or updated tuning items:

  • Optimized JVM switches for Oracle JRockit / Sun JVM / IBM JVM etc
  • New tuning parameters settings / values for JavaHost / OPIS / OBIS components.
  • Improved BIEE / platform performance monitoring techniques.
  • IBM WebSphere tuning parameters.
  • More WebLogic Server tuning parameters.
  • Windows Server 2012 tuning parameters.
  • New optimized Linux / AIX tuning parameters.
  • Additional Essbase ASO tuning parameters.
  • libOVD authenticator search tuning
    And many more….

Tuesday Jan 28, 2014

BI Check with WLST - SQL Datasources part 2

This second post continues with the BIEE security checks using WLST and python. This time, the following information is gathered about BISQLGroupProvider:

*  looking for SQLGroupProvider in the configured providers
*  retrieving the SQL queries
*  retrieving the JDBC source details
*  testing the connection pool, for each server that uses it (make sure your BI server is up and running)
*  testing the SQL queries directly against the database, with the test.user and test.group provided in the automation.properties file

[Read More]

Friday Jan 24, 2014

BI Check with WLST - Providers and Technical users part 1

 Checking OBIEE security configuration manually is relatively time consuming. Using WLST and Python, it is possible to automate most of these tasks. The following script performs checks on OBIEE configuration. It is the first of a 3 part series.[Read More]

Tuesday Jan 21, 2014

Essbase 11.1.2.x - Web Launched EAS Console jnlp

When using the web launched EAS Console with internet explorer (http://<servername>:10080/easconsole/console.html) for the first time , it is possible that you will be prompted to open, find or save the easconsole.jnlp.

[Read More]

Tuesday Jan 07, 2014

OBIEE 11.1.1: Load Testing Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Using Oracle Load Testing (OLT) 12.x

Published whitepaper on Load Testing Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Using Oracle Load Testing (OLT) 12.x) which can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1611188.1

(Oracle Support Document 1611188.1)

Monday Dec 09, 2013

OBIEE Web services with javascript

OBIEE web services provide a large set of operations on ibots, jobs, metadata, analysis, webcat...

A wsdl is provided for these services, and it is common to call them in a process running in Weblogic server (java custom application).  However, it is also possible to call them using javascript in a browser, or in a server with a javascript engine (Nodejs.org, or else).


[Read More]

Friday Nov 22, 2013

Calculations Using Dates Stored in Planning

Planning allows users to enter date values in Planning. For example, a start date can be entered as 11/01/2013 if the format is MM/DD/YYYY. Although the values are entered in date format, it is possible to calculate values based on dates entered.

[Read More]