Monday Feb 17, 2014

My Oracle Support Community - Subspaces

Further to our previous posting  "My Oracle Support Community - The New Look" (31-Jan-2014), here a few more details to assist with the new My Oracle Support Community (MOSC). 

The Business Analytics (BI/EPM) subspaces "Overview" pages can be quickly accessed via these quick links (NOTE: "My Oracle Support" login is required):

  • Business Intelligence
BI Patch Reviews
Certifications for BI
Oracle Endeca Information Discovery
  • Oracle Hyperion EPM

Hyperion Certification for EPM
Hyperion Essbase
Hyperion FDM
Hyperion Financial Close Management
Hyperion Other Products
Hyperion Patch Reviews
Hyperion Planning
Hyperion Reporting Products

The "Overview" page also provides functionality that includes both locating posts via a Search and filtering via Tags, along with options to Start a Discussion, setting to turn on Email Notifications and Communications Tracking for that subspace.

Select the "Content" tab to access all the new and previous Community Discussions and Documents.  Viewing any of these individual posts will provide the options to turn on email and/or "Communications" tracking for that post only - ensuring you are kept up to-date with any future thread updates on that post.

For the EPM and BI Product spaces and subspaces of interest - be sure to select the "Follow" button.  

Once "Following" this will also add the subspace to your profile "Places" list - which is a great way to quickly access those subspaces.  These can be listed by simply selecting:

  • Your Profile Picture (Avatar) | Places

For additional information review the previous Blog post  "My Oracle Support Community - The New Look" which provides details for two offerings that will assist in getting you started:

  • New "How To Series" Videos
  • Live Webcast sessions

These provide an overview of the new platform, steps on completing your profile setup, details on starting and reply to community discussions, and information on participating within the community.

Wednesday Feb 12, 2014

OBIEE certification against Web Browsers

(In via Julie)

One of the most common questions coming into Oracle Support is about Certification of OBIEE against various web browsers.

In the past there have been numerous articles relating to one or some of the browsers... well now we've gone ahead and consolidated this information into a single article:

OBIEE 11g - Browser Certification Advisor
Doc ID 1615805.2

Please go ahead and bookmark it. The advisor will be updated regularly and we hope it will become your single source of truth for browser certification information.

Feel free to add comments to the article or here in the blog if you want to find out more information, we're always seeking to improve on the information that's available.

Tuesday Feb 11, 2014

Port Numbers Used in an OBIEE 11g Installation and Configuration

(In via Tanya)

Did you ever wonder what port numbers are used during an Oracle Business Intelligence Enterprise Edition (OBIEE) installation and configuration?

To assist and help during installations and ongoing support a new document has been created:

Information Regarding Port Numbers Used in an OBIEE 11g Installation and Configuration
Doc ID 1619572.1

This document outlines the default ports, custom ports, instructions on how to determine active ports and much more.

It is definitely worthwhile reviewing this document prior to undertaking any installation or configuration.

Monday Feb 10, 2014

Integrating Essbase with OBIEE Tutorial

Available via the Oracle Technology Network (OTN) is the tutorial:

Integrating Oracle Essbase with Oracle Business Intelligence Suite Enterprise Edition

In this tutorial you learn how to integrate Oracle Essbase  with OBIEE Plus,undertaking the topics:

  • Importing a Multidimensional Data Source into Oracle BI Server
  • Using Modeling Techniques to Enhance Analysis
  • Performing Ad Hoc Analysis Using an Imported Multidimensional Data Source

As you go through the tutorial topics it will provide:

  • Instructions to connect to the Administration Tool
  • Steps to:
    - import two Essbase cubes into the Physical layer of the Presentation Services Catalog
    - copy the Essbase cubes from the Physical layer to the Business Model and Mapping and Presentation layers
    - create Answers requests and an Interactive Dashboard using the imported Essbase cubes

Note: Ensure to read the Software Requirements and Prequisites before starting.

For additional information for the Integration of OBIEE/Essbase refer to:

Master Note for OBIEE 10g and 11g Essbase Integration issues
Doc ID 1265441.1

Integrating OBIEE with Hyperion Smart View for Office

Available via the Oracle Learning Library (OLL)

Integrating Oracle BI EE with Oracle Hyperion Smart View for Office

This tutorial covers the connectivity available between Oracle Hyperion Smart View for Office and Oracle Business Intelligence Enterprise Edition (OBIEE)  Smart View provides a Microsoft Office interface for the content in the Oracle BI catalog. The approximate time to complete is 60 minutes.

 The Topic List this tutorial will step you through includes:

  • Setting Up Smart View
  • Inserting Oracle BI EE Views into Smart View Clients
  • Working with Views in Smart View Clients
  • Copying and Pasting Oracle BI EE Objects
  • Creating and Publishing Views Using the View Designer

Be sure to review the Overview section before starting for important information including the Hardware and Software requirements, and prerequisites.

Start now by visiting:
Integrating Oracle BI EE with Oracle Hyperion Smart View for Office

Seeking more information for OBIEE with Hyperion Smart View - visit our previous Blog Post:

HowTo Videos: Using Smart View to access data in OBIEE

This provides links to the "How To" video series which are available via the Oracle BI TechDemo YouTube Channel.

Friday Jan 31, 2014

Installation of BI Applications with Informatica PowerCenter 9.5.1

Update 4-Feb-2014: The Informatica .rep file for BI Applications in INFA 9.5.1 has been made available via Login Required Patch 18104144.

For updated information refer to:

NOTICE: Installation of BI Applications with Informatica PowerCenter 9.5.1"
Login Required
Doc ID 1615994.1

The following notice has been made for customers who are in the process of either installing or upgrading to Oracle BI Applications with Informatica PowerCenter 9.5.1 Hot Fix 2.

Included in the Business Intelligence 11g media pack is the Informatica .rep file for Oracle BI Applications V7.9.6.4 in Informatica PowerCenter V9.5.1 format. The part is titled 'Informatica Repository 9.5.1 for BI Applications' (part # V41981-01).

The Informatica .rep file provided is an incorrect development version. Do not use this file to restore the Informatica repository for BI Applications Drop this repository if you have already restored it.

For more information and details on how to restore the correct repository please read:

NOTICE: Installation of BI Applications with Informatica PowerCenter 9.5.1
Doc ID 1615994.1

My Oracle Support Community - The New Look

With the NEW My Oracle Support Community Platform Release just around the corner here is a great way to get a head start with the new look and feel.

Two offerings available to get you started:

  • Watch the New "How To Series" Videos
  • Attend Live Webcast session

These videos and the presentation session will not only assist with getting started, but will assist with your community interactions and strengthen your use of the new features. They will inform you of the MOS Community changes which brings enhanced search capabilities that return answers from discussions, content, and other resources. Learn about the new results sort options and other added functionality such as notification options.

Each of the "How To Series" videos cover a different aspect of the new My Oracle Support Community Platform and will explain what to expect. These are available now via My Oracle Support Knowledge articles:

My Oracle Support Community - How To Series [Video]:

Doc ID 1614073.1 - New Platform Overview (08:57)

Doc ID 1614358.1 - How to complete your profile setup (07:20)

Doc ID 1614724.1 - How to start a community discussion (08:49)

Doc ID 1614734.1 - How to reply to discussions (07:20)

Doc ID 1614725.1 - Participating in the community (08:07)

Register Now to attend one of the scheduled Live Webcasts.

With a duration of just 40 minutes, multiple languages and several dates/times to choose from we look forward to you joining us for one of these sessions.

Get Proactive Essentials Webcast Series - My Oracle Support Community
Doc ID 1615047.1

We hope that you enjoy the new look and feel, and find these videos and live Webcast sessions helpful for your preparation for the new My Oracle Support Community Platform.

Your participation is key to build a strong My Oracle Support Community.

Wednesday Jan 29, 2014

Oracle University: Hyperion Strategic Finance 11.1.2 Essentials

The Oracle University have announced a NEW course on their curriculum listing:

Hyperion Strategic Finance 11.1.2 Essentials

The course is aimed at Financial Analysts, End User and Business Analysts.  During the course:

  • learn how to use Oracle Hyperion Strategic Finance.
  • review the account structure, maintain sub accounts, and data views.
  • analyze account assumptions by drilling down on accounts.
  • learn about forecast methods, and about changing scenarios and comparing data under different scenarios.
  • review consolidation structures, and entity characteristics, and assign scenarios to consolidation structures.
  • establish target values for accounts, and you perform sensitivity analysis to evaluate the impact on key variables when you change selected account values.
  • prepare reports and review financial statements.
  • set funding options.
  • undertake exercises that provide hands-on practice.

The Oracle University provides the training formats in Classroom Training and Live Virtual Class (LVC).  For full details on the Hyperion Strategic Finance 11.1.2 Essentials course visit: 

Oracle Hyperion Strategic Finance 11.1.2 Essentials Ed 1
Oracle Hyperion Strategic Finance 11.1.2 Essentials Ed 1 LVC

Where there are no scheduled courses you may express your interest in adding a future class by  "Register a Request".

Interested in Oracle University courses for Hyperion products?  Visit "Hyperion Categories"

Course formats:

  • Classroom Training: You train in person at an Oracle or partner facility. Includes in-class demonstrations and hands-on labs.

  • Live Virtual Class (LVC): You watch live classes as they're happening, in real-time, from anywhere with an Internet connection. Oracle University Instructors teach live students in a "virtual" classroom; you attend these courses online. Includes demonstrations and hands-on labs.

OBIEE bundle patch for Linux 64-bit - Update

An update from previous Blog post  "OBIEE bundle patch for Linux 64-bit". 

A new replacement patch is now available
via My Oracle Support | Patches and Updates
Patch 17886497.

Important Note: If you have downloaded and applied the Patch 17886497 prior to 17-Jan-2014, Oracle recommends that, to be safe, download the new patch, roll back and apply the new patch.

Additional details are outlined in:

OBIEE on Linux 64-bit Might Generate Core Dump or Not Start
Doc ID 1616208.1

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.

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

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

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

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



« April 2014