Wednesday Mar 13, 2013
Wednesday Jan 16, 2013
By Olivier Bennardo-Oracle on Jan 16, 2013
INTRODUCTION SAP/BW DATA SOURCES SYTEM
SAP/BW integrates with BI tools via MDX (Multidimensional Queries), MDX is the de facto industry standard to query OLAP servers.
SAP/BW Server includes an MDX processor to directly query any BW INFOCUBE and INFOQUERY
SAP/BW supports multiple protocols to submit MDX requests:
With OBI EE 11g, both the XMLA adapter and the BAPI adapter are supportedRead More]
Monday Jul 16, 2012
By sujata on Jul 16, 2012
Issue: Charts are no longer rendering in IE or FF after applying OBIEE 184.108.40.206.2 BP1
The reason that charts are failing to render is due to the fact that our update process does not touch the custom directories (skins, styles). It will only update the default skins and styles directories (s_blafp and sk_blafp). The reason is that we do not want to overwrite any customizations done by customers / partners.
Note: If you are using a custom skins directory, you will have to copy the BIChart.swf from the default directory or the install directory into your custom skins directory. If you do not replace the file, the charts will not render. This change requires that the OracleBI Presentation Services Component be restarted via the opmnctl process as well as for the browser cache to be cleared. Once that has been done, you will be able to render the charts.[Read More]
Monday Apr 09, 2012
By Mshahi-Oracle on Apr 09, 2012
This Guide covers following topics:
- Administering BI Publisher
- Creating Data Models and Reports
- Viewing and Scheduling Reports
Click here to Download this Quick Start Guide.
By Mshahi-Oracle on Apr 09, 2012
Oracle BI EE 220.127.116.11.0 Bundle Patch 2 is available. The Patch number is 13611078 and it can be downloaded from Oracle Support (you can download it without password). This patch currently is available on Microsoft Windows x64 (64 bit), Linux x86 - 64 bit, IBM AIX on Power System (64 bit) and Oracle Solaris Sparc (64 bit). Remaining four platforms Win32, Linux32, HP-Itanium, and Solaris x86-64 are expected 3-4 weeks later.
This Patch has thoroughly been tested and signed off by BI QA Team.[Read More]
Wednesday Apr 04, 2012
By Ahmed Awan-Oracle on Apr 04, 2012
BI Client installer (version 18.104.22.168.0) does not install Oracle Database Client. Therefore for BI Admin tool client installations, the Oracle DB Client (11gR2) must also be separately installed on same windows machine.
Tip: If you install BI Client 32bit version, make sure to install Oracle Database Client 32bit version. Likewise If you install BI Client 64bit version then make sure to install Oracle Database Client 64bit version.
Thursday Mar 08, 2012
By Ahmed Awan-Oracle on Mar 08, 2012
In OBIEE releases 22.214.171.124 / 126.96.36.199, if the BI Office Server is configured to connect to Presentation Services through Oracle HTTP Server (OHS), then you might see intermittent error messages that are caused by the timeout of a request. To work around this issue, increase the Keepalive timeout 50 or more.
By Ahmed Awan-Oracle on Mar 08, 2012
In OBIEE releases 188.8.131.52 / 184.108.40.206, Scale-out scenarios of the BI domain are not supported on servers that have the same operating system but different patch levels. All servers must have the same operating system patch level.
Tuesday Mar 06, 2012
By Ahmed Awan-Oracle on Mar 06, 2012
a. First synchronize your mobile device (iPhone/iPad) with your computer
b. Crash logs stored under:
• Windows 7
– C:\Users\username\AppData\Roaming\Apple Computer\Logs\CrashReporter\MobileDevice\iPad2
• Windows XP
– C:\Documents and Settings\Application Data\Apple computer\Logs\CrashReporter\
• Mac OS X
Tuesday Feb 28, 2012
By Ahmed Awan-Oracle on Feb 28, 2012
To troubleshoot authenication issues etc in Oracle BI Mobile application, here are the basic steps to trace / get the Console Logs:
1. Download and setup iPhone Configuration Utility - Available from developer.apple.com
2. Connect device to computer.
3. Start iPhone Configuration Utility.
4. Go-to Console tab and Clear Console Output.
5. Launch Oracle BI Mobile application.
6. Set Console Logging “ON” .
7 Capture console output in Config Utility i.e. Save Console As...
Monday Feb 20, 2012
OBIEE 11.1.1 - After complete system restarts, getting “Error 404 – Not Found” when accessing OBIEE URL
By Ahmed Awan-Oracle on Feb 20, 2012
Getting “Error 404 – Not Found” when accessing OBIEE URL i.e. https://<server>:9704/analytics . Check whether the "analytics" deployment in WebLogic Server is in Active state in the console > Deployments. If not start the deployment.
Thursday Feb 09, 2012
OBIEE 11.1.1 - Unable to View PDF / graphs in Internet Explorer 7 and 8 over SSL using WebGate/OHS as front-end
By Ahmed Awan-Oracle on Feb 09, 2012
Set CachePragmaHeader and CacheControlHeader to public.
This setting applies only to WebGates. These settings control the browser's cache. By default, CachePragmaHeader and CacheControlHeader are set to no-cache. This prevents WebGate from caching data at the Web server application and the user's browser. However, this may prevent certain operations such as downloading PDF files, saving report files and displaying charts when the site is protected by a WebGate. You can set the Access Manager SDK caches that the WebGate uses to different levels. See http://www.w3.org/Protocols/rfc2616/rfc2616-sec14.html section 14.9 for details. All of the cache-response-directives are allowed.
1. For your OBIEE setup using WebGate, you may need to set both (CachePragmaHeader and CacheControlHeader) cache values to public.
2. For your OBIEE setup using OHS with mod_osso, to allow caching for SSO protected resources you need to add "OssoSendCacheHeaders off", in mod_osso.conf.
Wednesday Feb 08, 2012
By Nicolas Barasz-Oracle on Feb 08, 2012
In 10g, calculated items were created in one pivot table only. In 11g, all calculated items are shown in all views.
• The format of the report is modified: calculated items that were in one pivot table only before the upgrade now appear in all views.
• If a calculated item had the option ‘Hide details’ selected, showing this column in other views changes completely the results.
To replicate 10g behavior in 11g, you must:
• Add a new column identical to the one used to compute the calculated item.
• In all views except in the one that includes the calculated item, replace the old column by the new one.
Note that it is easier to perform this modification in 10g before the upgrade. It is possible to do it in 11g after the upgrade but then you have to compare 11g and 10g reports to find out which view the calculated item belonged to.
Wednesday Dec 21, 2011
By Ahmed Awan-Oracle on Dec 21, 2011
If you are having trouble connecting to an Oracle Database using OCI, check to ensure that the following conditions are true:
■ The computer running the Oracle BI Server must use Oracle Call Interface (OCI) to connect to the database.
■ If you choose not to use the entire connect string in the repository connection pool, you must ensure that a valid tnsnames.ora file is set up in the following location within the Oracle Business Intelligence environment, so that the Oracle BI Server can locate the entry:
■ If you choose not to use the entire connect string in the repository connection pool, ensure that the net service name in the tnsnames.ora file matches the Data Source Name used in the connection pool.
Wednesday Nov 02, 2011
OBIEE 11.1.1 - Error: "Too many running queries. Server is too busy to process any more queries at this time"
By Ahmed Awan-Oracle on Nov 02, 2011
During normal users load, OBIEE fails frequently with the following error:
"OAMP2OPY:GIQKCQ7 Too many running queries. Server is too busy to process any more queries at this time."
Possible Causes / Solution:
1. The Oracle Database instance is configured by default to run only 150 PROCESSES; the maximum load for dedicated connections is determined by the PROCESSES parameter. When the listener believes the current number of connections has reached maximum load, it may set the state of the service handler for an instance to "blocked" and begin refusing incoming client connections with the following error (in biserver1.log set in debug level):
"TNS-12516 TNS:listener could not find instance with matching protocol stack"
Tip: Verify the Oracle database processes parameter setting. It is also a good idea to make sure the Oracle database sessions and open cursors settings are large enough.
2. Increase the number of concurrent client connections (sessions) to OBI server. Each client request to OBI Server uses one SERVER_THREAD. Each SERVER_THREAD uses 0 or more DB_GATEWAY_THREADs depending upon the number of DB queries executed. Following NQSConfig.INI parameters need to be tuned (refer to OBIEE tuning guide for details on initial values to be set):
[ SERVER ]
3. Cleanup Web catalog via instanceconfig.xml using the steps documented in "Validating the Catalog" in System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.
4. In instanceconfig.xml file for each instance, add the following parameters within Cache/Query tags:
</Cache>5. Make sure you have enough system resources available on BI Servers (sawserver, nqsserver). 6. Unstable network connection link between OBIEE servers and Database server.
A blog focused on Tips & Tricks about Oracle Business Intelligence (OBI), Oracle Exalytics and Oracle Enterprise Performance Management (EPM) products.
[Blog Admin: Ahmed Awan] Please note the CEAL blog posts are for information and demonstration purposes only and are not official documentation or supported by Oracle Support.
Popular Whitepaper Downloads
- EPM 11.1.2.x – Planning/PBCS Best Practices for BSO Business Rule Optimisation
- OBIEE 12c: Integrating BI 12c with HFM
- OBIEE 12c: Creating a Custom Layer in MapViewer for use with VA
- OBIEE12c: Best Practices Guide for Infrastructure Tuning Oracle® Business Intelligence Enterprise Edition 12c (12.2.1)
- OBIEE 12c: Increasing the Node Manager JAVA Heap Size
- OBIEE 12c: Remove Init block users from the catalog
- OBIEE 12c: How to Revoke/Grant Data Visualizations Permissions using WLST
- Configuring BI 12c with IIS 8.5
- OBIEE 12c: External Subject Area Cache Configuration
- OBIEE 12c: User's group and application role are not applied