Category Archives: Performance Tuning

Oracle’s master notes for OBIEE

I’ve found few interesting Master Notes on support site that will be useful for everyone who wants to improve OBIEE’s performance in production (you must have Oracle’s support ID to login):

1. Note 740257.1 – How to Increase SAW Logging?
2. Note 1054009.1 – Instructions For Setting Up the Performance Monitor Counters (PERFMON) for Windows
3. Note 823193.1 – How Can We Add Database Hints to Our Custom Reports to Improve Performance?
4. Note 1181263.1 – How Do I Monitor My OBIEE Performance?
5. Note 1096900.1 – How To Troubleshoot Performance issues in OBIEE 10g?

Master note for Security:

1. Note 476617.1 – How to Set Up LDAP Security Within Siebel Analytics Repository
2. Note 749566.1 – 10.1.3.4 OBIEE on Linux Server Unable to Use LDAP
3. Note 978177.1 – How to Setup LDAP over SSL for OBIEE
4. Note 875324.1 – SSO Issue When Using the NQUser Variable on the URL
5. Note 540437.1 – Error Codes: WUDC2HWW – Using OBIEE With IIS and SSO
6. Note 974422.1 – Embedding Analytics in Oracle E-Business Suite
7. Note 988697.1 – Reporting Log In: (401)Unauthorized When Accessing BI Publisher from OBIEE in SSO Environment With IIS
8. Note 757957.1 – Integrating BI Office with OBIEE that has SSO
9. Note 886493.1 – Troubleshooting You are not currently logged in to the Oracle BI Server Error in OBI When SSO is Enabled
10. Note 1304942.1 – BI Servers Fail To Start And Node Manager Unreachable After Enabling SSL on OBIEE 11g and Admin Server
11. Note 1273913.1 – How To Move Or Migrate OBIEE 11g Roles, LDAP Users / Groups From Test To Production Environments.
12. Note 1314339.1 – What Authentication Mechanisms are supported in OBIEE 11.1.1.3
13. Note 1314357.1 – What SSO Mechanisms are supported in 11.1.1.3 ?

General Troubleshooting Docs for OBIEE Integration Issues :

1. 1082987.1 ALERT: Required and Recommended Patch Levels For OBIEE 10.1.3.x Versions
2. 740257.1 How to increase SAW logging?

SSO Integration with OBIEE :

1. 886493.1 Troubleshooting “You are not currently logged in to the Oracle BI Server” error in OBI when SSO is enabled.
2. 860234.1 Addition of LDAP authentication to BI Applications rpd causes BI server crash
3. 1074402.1 Integrating Oracle BI Enterprise Edition with PeopleSoft – without an SSO product

EBS Integration with OBIEE :

Following Documents can be reviewed if you are having errors/issues while integrating EBS and OBIEE :

1. 555254.1 Integrating Oracle Business Intelligence Applications with Oracle E-Business Suite
2. 758392.1 How to diagnose “You are not currently logged in to the Oracle BI Server..” error when login from EBS to OBI ?
3.8449681 CAN NOT USE OBIEE ANSWERS AS SOURCE FOR BI PUBLISHER INTEGRATED WITH EBS
4. 1067342.1 Is it possible to have 1 rpd and authenticate users from both Siebel and EBS in OBIEE ?
5.544722.1 Authorization Block Failed when populated from EBS database
6. 555254.1 Enabling Action Links in Oracle Business Intelligence Applications for Oracle E-Business Suite
7. 755768.1 OBIEE intregation with AD and R12 Ebusiness Suite
8. 756851.1 Document for implementing security OBIEE Apps with EBS and Siebel CRM as sources

Siebel Integration with OBIEE

1. 477579.1 Requirements for Web Server Setup in an Integrated Siebel Analytics Environment
2. 737516.1 Why does Action Link Dropdown not appear ?
3. 477113.1 Configuring Siebel Analytics version 7.5 integrated authentication mechanism
4. 475349.1 How To Embed Contextual Oracle Business Intelligence Content in Siebel Business Applications for Versions 7.5.x, 7.7.x, and 7.8.2 
5. 489010.1 Siebel SSO with Siebel Analytics – integration
6. 477377.1 Integrating Siebel Analytics with Siebel Applications

Portal Server Integration

1. 885282.1 How to deploy BI Portlet in Oracle portal
2. 1303275.1 Is OBI ReportUI Portlet Supported in OBIEE 11g?

Peoplesoft Integration

1. 1074402.1 Integrating Oracle BI Enterprise Edition with PeopleSoft – without an SSO product

2.Oracle Business Intelligence Applications Integration with PeopleSoft Enterprise Applications (with Oracle Single Sign-On) (Doc ID 1111804.1)

Finally, it’s official – Firefox has better performance than IE

Browser performance is a hot topic. I normally develop with Firefox, but from my experience, it’s a rare situation that Firefox is supported by company’s IT department. Hence, I need to use IE on a regular basis – and I can’t say I’m too happy.

I feel like Captain Obvious for re-posting this, but here you go:

IE takes significantly more time than Firefox to open a report.

There are two issues:

1. MacAfee anti-virus software was configured to scan the OBIEE files. As a result, a scan was done on every file when, using IE, which significantly degraded performance. Firefox did not scans any of  the files, and therefore, was much faster.

2. Fundamental differences in the browsers. For example.. IE is built in as part of the OS, while Firefox is standalone.

To minimize the performance differential between IE and Firefox:

First of all, disable virus scanning on any Analytics (OBIEE) folders, and also, the web server folder where cache files are generated.

Secondly, Oracle does recommend any specific settings for either IE or Firefox, however, it is generally acknowledged that Firefox is a faster browser than IE. The explanation for this is that IE is embedded into the OS, whereas Firefox is a standalone application. The effects of this are:

  1. Memory Management: IE doesn’t do memory cleanup, because it is done by the OS. Firefox, however, only has to interact with the OS, where it does a better job of managing memory resources, first reserving, and then releasing memory to be reused faster.
  2. Network issues: IE being integrated into Windows uses the network settings from Windows, whereas Firefox can more efficiently figure out which settings to use.

Firefox eats IE in OBIEE

Readership Survey

I’d appreciate if you could take a minute of your time and answer a few questions. I’ll try to use that input in making this site more useful and interesting for you.  I’m trying to get a feel on possible improvements and enhancements.  Some of the things I consider adding – a star-rating system for posts, bulletin-board / discussion board, and recommendation services. P.S. In the end of the survey it’ll ask you for Name / E-mail – Please ignore it and just click on Submit Survey. I’ll try to publish results once I get a meaningful sample.

[SURVEYS 1]

Oracle BIEE 10.1.3.4 TMP and Cache Files Still in Original Path After Modifying NSQConfig.ini File

Modified the NQSConfig.ini file to change the TMP directory and the DATA_STORAGE_PATH (Cache).
Restarted the BI server and presentation server and noticed that files are not being written to the expected locations.

For example, the TMP directory was changed from:

WORK_DIRECTORY_PATHS = “/u01/app/oracle/product/10.1.3/obiee/OracleBIData/tmp”;

To:
WORK_DIRECTORY_PATHS = “/obi-tmp/tmp”;

The DATA_STORAGE_PATH was changed from:
DATA_STORAGE_PATH = “C:\OracleBI\server\Data\Temp\Cache” 500 MB ;

To:
DATA_STORAGE_PATH = “/obi-tmp/cache” 500 MB;

After making these changes, the TMP and cache files are still being written to the original locations.
Cause

Cache and TMP file locations are controlled by NSQConfig.ini parameters and the SATEMPDIR environment variable.
While the NSQConfig.ini file had been partially updated, the SATEMPDIR had not been updated at all.

The cache settings need to be updated in the NSQConfig.ini file under “[MDX_MEMBER_CACHE]” and “Query Result Cache Section.”

If the SATEMPDIR environment variable is not set and both cache locations are not updated in the
NSQConfig.ini file, the files will continue to write to the default locations.
Solution

Please complete/verify the following steps to change TMP and Cache File locations:

1. Open the NQSConfig.ini file and verify/modify desired paths for the TMP and Cache files.
You should leave original values in the file, but prefix with a “#” symbol to comment out the value.
For example:

TMP Files

#WORK_DIRECTORY_PATHS = “/u01/app/oracle/product/10.1.3/obiee/OracleBIData/tmp”;
WORK_DIRECTORY_PATHS = “/obi-tmp/tmp”;

Cache Files

Query Result Cache Section

[ CACHE ]

ENABLE = NO;
// A comma separated list of <directory maxSize> pair(s)
// e.g. DATA_STORAGE_PATHS = “d:\OracleBIData\nQSCache” 500 MB;
#DATA_STORAGE_PATHS = “/u01/app/oracle/product/10.1.3/obiee/OracleBIData/cache” 500 MB;
DATA_STORAGE_PATHS = “/obi-tmp/cache” 500 MB;

[ MDX_MEMBER_CACHE ]

#DATA_STORAGE_PATH = “/u01/app/oracle/product/10.1.3/obiee/OracleBIData/cache” 500 MB;
DATA_STORAGE_PATH = “/obi-tmp/cache” 500 MB;

2. Then update the SATEMPDIR environment variable to show the same physical path as the WORK_DIRECTORY_PATHS variable in the NSQConfig.ini file (“/obi-tmp/tmp”).
The SATEMPDIR is only applicable to the TMP files.

NOTE: On Linux/Unix systems, this environment variable is defined in the common.sh file in the OracleBI/setup directory.

On Windows, the SATEMPDIR is defined under System Settings -> Advanced -> Environment Variables.

3. After making these changes, stop the BI Presentation Server and BI Server. Then restart.

4. After restarting, you will see .tmp and cache files written to the new directories.

What rule is followed when several fact are at the same content level ?

I think this is an interesting question especially for those who would like to know how BI “thinks”.

The goal is to understand what rule is followed when several fact are at the same content level

Normally the server uses the content level to pick the correct fact table.

The server is looking for the most aggregated source.

First choice is a query in which the grain of the query matches the grain of the content filter.
If there are no sources which match that criteria, it will look to other means to chose.

It looks at how many dimensions are associated with the fact table (size of the content filter), levels of the content filter, number of values from the level definitions multiplied.