Wednesday Jan 29, 2014

OBIEE Tuning Guide Whitepaper - update available

(In via Ahmed)

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:

OBIEE 11g Infrastructure Performance Tuning Guide
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ā€¦.

Disclaimer: All tuning information stated in this guide is only for orientation, every modification has to be tested and its impact should be monitored and analyzed. Before implementing any of the tuning settings, it is recommended to carry out end to end performance testing that will also include to obtain baseline performance data for the default configurations, make incremental changes to the tuning settings and then collect performance data. Otherwise it may worse the system performance.

Tuesday Jan 28, 2014

Smart View Documentation

Following on from the recent posting for "Patch Release: Smart View" - now available for download is the:

Oracle Smart View Documentation

The documents include:

  • Smart View for Office Readme
  • Smart View for Office New Features
  • Smart View for Office User's Guide
  • Smart View for Office Developer's Guide
  • Smart View for Office Accessibility Guide

These Oracle Smart View documents are available in HTML, PDF, MOBI and EPUB formats and can be access via the Oracle Documentation Library here


  • MOBI files are supported on Amazon Kindle devices
  • EPUB files are supported on mobile devices.

Friday Jan 24, 2014

Patch Release: Smart View

The Smart View Patch Set Update has been released.

Hyperion Smart View Patch Set Update (Patch 18077081)
Doc ID 1616238.1

The patch download & related Readme documentation is available via:

My Oracle Support | Patches & Updates:
Patch 18077081

You can upgrade to Smart View release from 11.1.2.x and  When upgrading from release and earlier, Oracle recommends uninstalling Smart View before installing release

Ensure to review the Readme documentation for important details including information on installation and listing of fixes this release covers.

Update (28-Jan-2014): The Oracle Smart View Documentation is available from Oracle Documentation Library [ Link]. 

If you are coming from Release,,,,, or, use the Cumulative Feature Overview tool to review the list of new features added between those releases.  This tool enables you to identify your current products, your current release version, and your target implementation release version. With a single click, the tool quickly produces a customized set of high-level descriptions of the product features developed between your current and target releases.

This tool is available here:

EPM System Cumulative Feature Overview Tool
Doc ID 1092114.1

Wednesday Jan 22, 2014

OBIEE bundle patch for Linux 64-bit

OBIEE bundle patch is not currently available on Linux 64-bit.

The patch has been withdrawn.

If you have already downloaded and applied it to Linux 64-bit, you might experience that OBIEE will not start or will generate core dump.

More information can be found in note 1616208.1 - OBIEE on Linux 64-bit Might Generate Core Dump or Not Start.

 A new patch will be made available in the near future and we'll update the blog at that time.

Update (29-Jan-2014): The OBIEE bundle patch for Linux 64-bit is now available refer: Blog Post

Monday Jan 20, 2014

My Oracle Support - IE7 Browser Certification

Important information for those using Internet Explorer 7 (IE7)

My Oracle Support

On April 4th, 2014 Oracle Support will remove Internet Explorer 7 (IE7) from the My Oracle Support (MOS) and Cloud Support portal certified browser list.

It is important that you make the transition to a more current version of Internet Explorer prior to this.

For questions relating to this change please use the  MOS "Contact Us" link located in the upper right hand corner.

For more information ...  Read Me

Friday Jan 17, 2014

ADVISOR WEBCAST: Embedding OBIEE Content in WebCenter Portal

Now Scheduled

Advisor Webcast

Embedding OBIEE Content in WebCenter Portal

19th March 2014

This one hour session is recommended for technical users who are interested in integrating OBIEE with WebCenter Portal. The objective is to provide an overview of the system requirements and the steps required to perform a basic integration.


  • Understand what is required in order to integrate OBIEE with WebCenter Portal
  • Have an idea of what issues may occur, how to debug them and what log files may be required

Register Now - visit:

Embedding OBIEE Content in WebCenter Portal [Doc ID 1613815.1]


To view scheduled & archived recordings of previous Business Analytics Advisor Webcasts visit:

Oracle Business Analytics Advisor Webcast [Doc ID 1456233.1]


Attendees using recent Chrome or Firefox browser versions maybe required to activate the WebEx plug-in before joining a WebEx meeting.

For up to-date information ensure to review the WebEx Support page:

Wednesday Jan 15, 2014

Oracle BI Mobile HD Now Available

A NEW version of the Oracle Business Intelligence Mobile HD app has been released.

The Oracle Business Intelligence Mobile is designed for Apple iPhone and iPad. It is a mobile analytics app that allows you to view, analyze and act on Oracle Business Intelligence 11g content.

  • Using Oracle Business Intelligence Mobile, you can view, analyze and act on all your analyses, dashboards, scorecards, reports, alerts and notifications on the go.

  • Oracle Business Intelligence Mobile allows you to drill down reports, apply prompts to filter your data, view interactive formats on geo-spatial visualizations, view and interact with Dashboards, KPIs and Scorecards.

  • You can save your analyses and Dashboards for offline viewing, and refresh them when online again; thus providing always-available access to the data you need.

  • This app is compatible with Oracle Business Intelligence 11g, version and above.

Now available for download via Apple store [ Link]

Updated: Jan 14, 2014
Size: 17.0 MB

OBIEE Version Now Released

(in via Ian)

The Oracle Business Intelligence Enterprise Edition (OBIEE) is now available to download via My Oracle Support | Patches & Updates. 

This is provided as single Bundle Patch:  Patch 17886497 and comprises of the following:

  • Patch 16913445 - 1 of 8: Oracle BI Installer (BIINST)
  • Patch 17922352 - 2 of 8: Oracle BI Publisher (BIP)
  • Patch 17300417 - 3 of 8: EPM Components Installed from BI Installer (BIFNDNEPM)
  • Patch 17922552 - 4 of 8: OBI Server (BIS)
  • Patch 17922596 - 5 of 8: Oracle BI Presentation Services (BIPS)
  • Patch 17300045 - 6 of 8: Oracle Real-Time Decisions (RTD)
  • Patch 16997936 - 7 of 8: Oracle BI ADF Components (BIADFCOMPS)
  • Patch 17922577 - 8 of 8: Oracle BI Platform Client Installers and MapViewer

NOTE: Also required to be downloaded:

This patch set is available for all customers who are using Oracle Business Intelligence Enterprise Edition, and  It is also available for Exalytics customers who have applied the Exalytics PS3 patch.

For more information refer to:

 OBIEE 11g Bundle Patch is Available for OBIEE and Exalytics
[Doc ID 1614076.1]

The OBIEE Suite Bundle Patches are cumulative - the content of the previous bundle patches are included in this latest bundle patch.

Ensure to review the Readme documentation for further important patch information.  This available via the My Oracle Support | Patches & Updates screen when downloading.

Keep up to-date with the latest OBIEE Patches and Patch Set Updates by visiting

OBIEE 11g: Required and Recommended Patches and Patch Sets
[Doc ID 1488475.1]

Monday Jan 13, 2014

HowTo Videos: Using Smart View to access data in OBIEE

A series of "How To" videos are available via the Oracle BI TechDemo YouTube Channel

The collections covers various topics detailing how to use Oracle Smart View to access data in Oracle Business Intelligence Enterprise Edition (OBIEE) and display it in Microsoft (MS) Office (Excel, Power Point). The examples used were built using the Sample App v309.

Oracle BI TechDemo - OBIEE Samples

How To Videos: Smart View with OBIEE Link

Smart View with OBIEE - Managing Connections
- How to create and maintain connections between Oracle Smart View (MS Excel) and OBIEE.

Duration: 2:34 minutes

Smart View with OBIEE - Accessing Reports on the Web Catalog
- How to find and select reports on the OBIEE Web Catalog through Smart View.

Duration: 5:31 minutes

Smart View with OBIEE - Reporting through MS Power Point
- Selecting and delivering reports and graphics through MS Power Point using Smart View with OBIEE.

Duration: 2:45 minutes

Smart View with OBIEE - How to use View Designer
- How to use the View Designer to create reports and graphics in Smart View

Duration: 3:52 minutes

Smart View with OBIEE - Federating multiple data sources
- How to populate an Excel worksheet with data from multiple sources (in his example OBIEE and Oracle Essbase).

Duration: 3:54 minutes

Stay Tuned for New Upcoming Videos at:

Oracle BI TechDemo - OBIEE Samples

OBIEE 11g: Testing Using Oracle Load Testing 12.x

(in via Ahmed

Now available - NEW whitepaper for Load Testing Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Using Oracle Load Testing (OLT) 12.x.

This whitepaper produced via "Customer Engineering & Advocacy Lab" (CEAL) contains information to provide a quick start for performance / load testing of the OBIEE 11g infrastructure using Oracle Application Testing Suite (OATS).  The contents include:

  • Oracle Application Testing Suite (OATS) Overview
  • OBIEE Load / Performance Testing Process Using OATS

The PDF document is available for download from the "My Oracle Support" Knowledge document:

OBIEE 11g: Load Testing OBIEE Using Oracle Load Testing (OLT) 12.x
[Doc ID 1611188.1]

Thursday Jan 09, 2014

OBIA: Upgrading to Informatica PowerCenter 9.5.1 Hot Fix 2

Informatica PowerCenter 9.5.1 Hot Fix 2 is now available in the Business Intelligence (BI) 11g media pack for download and use with BI Applications 7.9.x

By upgrading to Informatica PowerCenter 9.5.1 Hot Fix 2, customers can avail of support for Informatica PowerCenter on higher versions of operating systems, support for the Oracle Business Analytics Warehouse on higher versions of database platforms, and bug and security fixes.

To assist with the upgrade a New Whitepaper has been made available. This document covers information on downloading, the upgrading and configuring.  The Whitepaper is available via the "My Oracle Support" Knowledge article:

"Oracle BI Applications: Upgrading to Informatica PowerCenter 9.5.1 Hot Fix 2"
[Doc ID 1610752.1]

Ref: OracleBIApps_UpgradeINFAPowerCenter_9.5.1HotFix2_Doc_ID_1610752.1.docx

Wednesday Jan 08, 2014

Remote Diagnostic Agent 8.02 is now available

(in via Maurice)

The Remote Diagnostic Agent 8.02 was released on 15 December 2013.

This version has five new Hyperion modules within the RDA profiles:

  • Collects Oracle Hyperion Financial Data Management Information (BI.FDM module)
  • Collects Oracle Hyperion Disclosure Management Information (BI.HDM module)
  • Collects Oracle Hyperion Profitability & Cost Management Information (BI.HPC module)
  • Collects Oracle Hyperion Performance Scorecard Information (BI.HPS module)
  • Collects Oracle Hyperion Strategic Finance Information (BI.HSF module)

Note that Remote Diagnostic Agent requires the run of Hyperion profiles (not individual modules).  A Hyperion profile name begins 'Hyperion1112_' and concludes with the key module abbreviation in capitals.

It is recommended that the ORACLE_HOME of the Oracle database client be defined (set ORACLE_HOME=C:\Oracle\Middleware\jdk160_21) for the EPM Server hcve Tool (rda.cmd -T hcve) and Hyperion profiles which collect information from the Hyperion Oracle database registry.

Download the newest version via the Knowledge article:

 "Remote Diagnostic Agent (RDA) - Getting Started"
[Doc ID 314422.1].

For details on how to use RDA specifically for the EPM and BI products refer to:

"Business Analytics Instrumentation Index [Video]"
[Doc ID 1514548.1]

Oracle Disclosure Management Financial Reporting Data Source Tagging Statement of Direction

The Product Management team have published a Statement of Direction regarding the Oracle Hyperion Financial Reporting XBRL data source tagging functionality in Oracle Hyperion Disclosure Management.

For those that create and use XBRL tags - ensure to review the Statement of Direction (PDF) and additional details available in:

 Oracle Disclosure Management Financial Reporting Data Source Tagging
Statement of Direction
[Doc ID 1609059.1]

Information on the Oracle Lifetime Support Policy and the services offered under the Premier, Extended and Sustaining Support stages is available here (PDF).

December EPM "Patch Set Updates" released (updated)

(in via Stefanie)

The following provides a listing of all Enterprise Performance Management (EPM) Patch Set Updates (PSU) that were released last month (December 2013). This list also includes the PSU's that were referenced on an earlier Blog post.

Refer to the "Doc ID" for each of the products for additional information.  These KM documents also provide a link to each of the PSU Patches.  The "Patch" ID links will access the patch directly for download.

Hyperion Shared Services [Doc ID 1606225.1]
     - Patch 17735854

Hyperion Essbase [Doc ID 1603891.1]
     - Patch 17608117: Server
     - Patch 17608120: Client (Windows):
     - Patch 17608110: Client (Non-Windows):
     - Patch 17608114: Runtime Client
     - Patch 17608122: Spreadsheet Add-In

Hyperion Essbase [Doc ID 1609805.1]
    - 17545111: Server
    - 17545113: Runtime Client

Hyperion Essbase Studio [Doc ID 1609860.1]
     - 17545104: Studio Server
     - 17545096: Studio Console

Hyperion Analytic Provider Services [Doc ID 1603937.1]
     - Patch 17595830

Hyperion Analytic Provider Services [Doc ID 1609861.1]
     - Patch 17545091

Hyperion Essbase Administration Services [Doc ID 1609889.1]
     - Patch 17545122: Administration Server
     - Patch 17545124: Administration Console

Hyperion Strategic Finance [Doc ID 1603155.1]
     - Patch 16942313

Hyperion Strategic Finance [Doc ID 1609555.1]
     - Patch 17800039

Hyperion Data Relationship Management [Doc ID 1603155.1]
     - Patch 17844222

Hyperion Data Relationship Management [Doc ID 1606660.1]
     - Patch 17889411

Hyperion Data Relationship Management [Doc ID 1603376.1]
     - Patch 17456597

Hyperion Data Relationship Management [Doc ID 1606266.1]
     - Patch 17860886

Hyperion Calculation Manager [Doc ID 1603907.1]
     - Patch 17649127

Hyperion Planning [Doc ID 1611323.1]
     - Patch 17919873

Hyperion Financial Management [Doc ID 1612782.1]
     - Patch 1740222

Be sure to review the related Readme files
available per Patch Set Update

... for the latest EPM & BI Patch Sets & Patch Set Updates visit:

Doc ID 1400559.1 - Oracle Hyperion EPM Products
Doc ID 1525518.1 - Oracle Crystal Ball, DRM, FCM, HPCM and HSF
Doc ID 1488475.1 - OBIEE 11g

Tuesday Jan 07, 2014

Business Analytics Monthly Index - December 2013

Wishing all a very Happy New Year for 2014. To "kickstart" the month off here is a quick review of the Proactive Support Blog postings from the previous month.

Welcome to the Monthly Index posting for December 2013.

Within each section the items are shown in chronological order.

Oracle Business Analytics - Blog

Monthly Index - December 2013
General Summary Link
November 2013 Index Posting
- Review the previous months Index page.
Business Intelligence (BI) Summary Link
OBIEE Version Name Change
- Summary outlining the recent version number change.
Enterprise Performance Management (EPM) Summary Link
December EPM Patch Setup Updates released
- Listing of EPM Patches released since previous Blog post advisory.
Financial Close Management Online Tutorials
- Listing of available tutorials available for for FCM
Patch Release: Financial Data Quality Management Enterprise Edition
- Summary details of the PSU for FDMEE.
Advisor Webcast Summary Link
Advisor Webcast: OBIEE 11g Diagnostic Tools and How to Use Them
- AW: Discussing the available OBIEE diagnostic tools & how to use them to resolve problems & errors.
  (the post presentation recording is available via Doc ID 1599274.1)
Advisor Webcasts Recap For 2013
- Summary of all EPM & BI Advisor Webcasts hosted during 2013.
For more information on future webcasts and archived recordings
visit Doc ID 1456233.1.

This blog talks about the latest news and upcoming events initiated by the EPM/BI Proactive Support Team.



« April 2014