Tuesday Nov 18, 2014

Adding trim functions to the column expressions in ODI

When OBIA adaptors extracts data from PSFT source, the data can be padded with spaces. The PSFT system stores the data in db with padded spaces and when it is taken across OBIA warehouse without applying trim function in the ODI maps, the warehouse will also have the data with padded spaces. Blog gives an example of how to fix these type of issues at the implementation time.


[Read More]

Monday Nov 17, 2014

EPM 11.1.2.3.500 - Enable HFM Thin Driver on Exalytics server

In EPM 11.1.2.3.500, FR web is deployed on Exalytics server enable the HFM thin driver by setting "UseHFMThinDriver" to “true” in jconsole (FRConfig.sh). Once enabled then restart all the services on Exalytics and HFM services on Windows.

FRConfig.sh is located under:  <Middleware_Home>/EPMSystem11R1/products/financialreporting/bin


Thursday Oct 16, 2014

Getting started with Weblogic Scripting Tool for OBI

This white paper will guide you setting up a development environment, get you started with basic script writing, and point you to useful documentation. We will focus on the interactive and script mode, for embedded mode, please refer to the documentation for examples about instantiating the WLST interpreter in your Java code and using it to run WLST commands and scripts.
[Read More]

Saturday Sep 20, 2014

Exalytics OVM 3.2.x - Increase Send Queue Length (txqueuelen) for VM guest (DomU) VIF

For VM guest (DomU) VIF interface, by increasing the Send Queue Length (txqueuelen) from 32 or 500 to 10000 can increase network performance 50%.

a. How to Increase Send Queue Length in Dom0:

In Dom0, you need to perform following permanent changes to make the txqueuelen to 10000:
1. Run below ifconfig script by crontab and it will automatically set 10000 for all the VIFs:
ifconfig | grep -P '^vif\d+\.\d+' |  awk '{system("ifconfig "$1" txqueuelen 10000")}'

2. Edit /etc/rc.local and append the following setting per interface:
ifconfig eth0 txqueuelen 10000
ifconfig eth1 txqueuelen 10000

3. It is recommended to perform sanity check that txqueuelen is set to 10000 for all the VIFs in Dom0 when VM guest (DomU) is restarted.

b. How to Increase Send Queue Length in VM Guest (DomU):

In VM guest (DomU), you need to perform following permanent changes to make the txqueuelen 10000:
1. Edit /etc/rc.local and append the following setting eth0 interface only:
ifconfig eth0 txqueuelen 10000

2. It is recommended to perform sanity check that txqueuelen is set to 10000 for eth0 interface when VM guest (DomU) is restarted.


Tuesday Sep 09, 2014

Using the @CURRMBR Function

Using the @CURRMBR Function

Essbase provides a suite of calculation functions to facilitate the definition and development of complex member formula calculations. The @CURRMBR calculation function is especially useful with scoping and managing complex calculations. The @CURRMBR (dimension) function is used to return the name of the member currently being calculated in the specified dimension.

[Read More]

Thursday Jul 17, 2014

Configuring OBIEE 11.1.1.7.x with Full End to End SSL

What do we need to configure SSL:
1. CA Root Certificate
2. CA Intermediate Certificate (if exists)
3. Java Keystores :: Identity Keystore and Trust Keystore
4. OBIEE Server Certificate
5. If External LDAP Directory like Oracle Internet Directory running in SSL
   OID Server’s CA Root Certificate
   OID Server’s CA Intermediate Certificate (if exists)
   OID Server Certificate

[Read More]

Tuesday Jul 15, 2014

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

Issue:

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.

Workaround:
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 11.1.2.3 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 11.1.1.6 to 11.1.1.7.x

Tips:

Use the Test to Production (T2P) / cloning process (movement scripts). For example:
– Clone up the existing 11.1.1.6 environment.
– Move the cloned copy to the new location / host (same 11.1.1.6.0 version at this point).
– Patch new location / host (11.1.1.6) to the 11.1.1.7 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 11.1.1.6 and 11.1.1.7.x

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

In 11.1.1.6, 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 (11.1.1.6, 11.1.1.7) 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….