Friday Nov 15, 2013

Advisor Webcast: OBIEE 11g Diagnostics Tools

Now Scheduled

Advisor Webcast

OBIEE 11g Diagnostics Tools and How to Use Them

Coming Soon in December 2013

This one-hour session is recommended for technical and functional users to learn more about the different diagnostic tools available with OBIEE and how to use them to resolve problems and errors in OBIEE.


  • Know all the diagnostic tools available
  • Where to find their output
  • How to use them to troubleshoot problems

Register Now - visit Document 1599274.1


For additional information refer to
OBIEE 11g Diagnostics Tools and How to Use Them [ Doc ID 1599274.1]

Friday Nov 08, 2013

November EPM Patch Set Updates released

(in via Greg)

Greg has provided us an updated listing of current patches for the EPM system.  These follow on from our previous Blog post last month in October [link].

17320505 - Oracle Hyperion Reporting and Analysis for Foundation - PSU
17413112 - Oracle Hyperion Planning, Fusion Edition - PSU
- Oracle Hyperion Reporting and Analysis for Financial Reporting - PSU
17609530 - Hyperion Essbase RTC - PSU
17609535 - Hyperion Essbase Server - PSU
17609533 - Hyperion Essbase Client - PSU
17609539 - Hyperion Essbase Client MSI - PSU
- Hyperion Essbase Administration Services Server - PSU
17609497 - Hyperion Essbase Administration Services Console MSI - PSU
- Hyperion Analytic Provider Services - PSU
16692973 - Oracle Hyperion Enterprise Performance Management - PSU
16984944 - Oracle Hyperion Financial Close Management - PSU
16989110 - Oracle Hyperion Financial Close Management - PSU
17636270 - Hyperion Strategic Finance - PSU

Be sure to review the related Readme files available per Patch Set Update.  These describe the defects fixed and/or updates included along with requirements and instructions for applying the patch. To access simply click on the "Read Me" button when accessing the PSU via My Oracle Support | Patches & Updates.

At any time to see listing of the latest Enterprise Performance Management (EPM) Patch Sets and Patch Set Updates for the current releases visit:

Doc ID 1400559.1 - Available Patch Sets and Patch Set Updates for Oracle Hyperion EPM Products
Doc ID 1525518.1 - Available Patch Sets and Patch Set Updates for Oracle Crystal Ball, DRM, FCM, HPCM and HSF

For OBIEE keep up to-date with the latest Patches and Patch Set Updates by visiting:

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

Friday Oct 25, 2013

OBIEE version has been released

The Business Intelligence Enterprise Edition patch set has been released, and is available to download from My Oracle Support (https:\\

Per the patch readme:
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.

Patch 17530796 - OBIEE BUNDLE PATCH (Patch) is comprised of the following patches, which are not available separately:

    Patch 16913445 - Patch (1 of 8) Oracle Business Intelligence Installer (BIINST)
    Patch 17463314 - Patch (2 of 8) Oracle Business Intelligence Publisher (BIP)
    Patch 17300417 - Patch (3 of 8) Enterprise Performance Management Components Installed from BI Installer (BIFNDNEPM))
    Patch 17463395 - Patch (4 of 8) Oracle Business Intelligence Server (BIS)
    Patch 17463376 - Patch (5 of 8) Oracle Business Intelligence Presentation Services (BIPS)
    Patch 17300045 - Patch (6 of 8) Oracle Business Intelligence Presentation Services (BIPS)
    Patch 16997936 - Patch (7 of 8) Oracle Business Intelligence Presentation Services (BIPS)
    Patch 17463403 - Patch (8 of 8) Oracle Business Intelligence Platform Client Installers and MapViewer

Also you must download:

Patch 16569379 - Dynamic Monitoring Service patch

The instructions to apply the bundle patch are given in the patch readme along with some important notes if you are upgrading from versions.

The new functionality in this patch includes:

    Support for Microsoft Internet Explorer 10
    Support for Oracle BI Mobile App Designer
    Support for improved exporting functionality into Microsoft Excel

For more information please refer to document:

OBIEE 11g is Available for Oracle Business Intelligence Enterprise Edition and Exalytics (Doc ID 1595219.1)

In addition we strongly recommend you review this document:

OBIEE Suite Bundle Patches (Doc ID 1591422.1), which explains the new naming convention, the strategy behind bundle patches and other interesting facts about OBIEE patching. Please take some time to review it.

Tuesday Oct 15, 2013

Introducing the Business Analytics Proactive Support Team

Dear Reader,

So you're reading this blog and its all pretty cool but have you ever wondered who are these "Proactive" people behind the blog and what exactly do they do?
Well here's a visual to help you out. It pretty much sums up our tasks: 

(click to enlarge)

The Business Analytics Proactive team are a team of 11 engineers located worldwide focused on getting information out to you as quickly and efficiently as possible. We're close to the SR-handling arm of the org so we get to know the common hurdles and questions coming in.

Our job is to try to pre-empt these questions thereby improving your overall experience with our products.

We also get involved in knowledge management, product improvements, diagnostics and testing.

So say hello to :

  • Paul (AU, Brio/BI+)
  • Nancy (US, Essbase)
  • Debbie (UK, Essbase/OBIEE)
  • Greg (UK, HFM)
  • Tanya (US, OBIEE, HFM)
  • Mel (UK, HFM/Enterprise)
  • Martin (DE, OBIEE)
  • Ian (UK, OBIEE)
  • Julie (UK, WCP/OBIEE )
  • Maurice (UK, BI/automation) and
  • Torben (DE, Essbase)

You'll see them pop up on LinkedIn occasionally as well as in  MOS Communities and you may even bump into them during a SIG or user group. We'll let you know where they'll be loitering next in the  'Meet the team' section.

Friday Oct 11, 2013

Update to OBIEE Chrome 30 issue

A few days ago we blogged about the issue with OBIEE and Chrome update 30.

Please note Patch 16068402 has just been posted to My Oracle Support ( Download and apply this patch to OBIEE

For those using please upgrade to latest patchset. The fix is included in and above (so in, automatically).

This is also explained in KM article:

OBIEE 11g: Chrome 30 and Pop-up Windows not Displayed
Doc ID 1590991.1

Update 11-Feb-2014: Please note patchsets (released Oct 25) and (released Jan 15) supercede this patch, Chrome 30 will work.

Tuesday Oct 08, 2013

OBIEE problems with Chrome (update 30)

(in via Akhter)

You may have noticed that OBIEE has a problem with the latest Google Chrome update 30 ( specifically version 30.0.1599.66 ).

I was informed by Support that Development is aware of the issue and we have multiple open Bugs logged for this.

Symptoms may include (but are not limited to):

  • not being able to edit an Analysis in Answers
  • not being able to view the catalog
  • popups are blocked although they are specifically allowed
  • In nqsserver.log, it generates some 'FailedAuthentication : The security token can not be authenticated'
  • When opening the 'Catalog' it just freeze the screen.
  • When opening a report, you get
       'View Display Error'
       Assertion failure: criteria at line 437 of
       Error Details
       Error Codes: ACIOA5LN

In case that you do encounter an issue with OBIEE and Chrome, please continue to log Service Requests for the issue at hand. But you may also inform the Support Engineer that you are aware of this being a broader problem.


Patch 16068402 has just been posted to My Oracle Support ( ). Download and apply this patch to OBIEE

For those using please upgrade to latest patchset. The fix is included in and above (so in, automatically).

OBIEE Sample App (V309 R2) released

As you may have heard via the newsletter or other channels, the 

OBIEE Sample App v. 309 R2 

has been released via  OTN.
( The public V309 image is approximately 23GB zipped and 59GB once deployed. )

To quote from the release site:

The Sample Application (SampleApp) for Oracle Business Intelligence Suite Enterprise Edition is a comprehensive collection of examples designed to demonstrate Oracle BI capabilities and design best practices.
It brings together several integrated Oracle BI products & technologies and illustrates how they can seamlessly work together in solving functional problems.
These examples include latest OBIEE functionalities and OBIEE architecture examples

  • Semantic layer modeling
  • Multi-source federation
  • Integration with Essbase
  • Integration with ORE
  • Integration with Endeca
  • Integration with TimesTen
  • and more

The SampleApp contents and its code are distributed free for demonstrative purposes only.
It is neither maintained nor supported by Oracle as a licensed product.

A quick overview of its contents is also available via the Oracle BI Techdemo Youtube channel and detailed product information can be found in the user guide.
The Deployment Guide will give you all necessary information on how to set up a system with the Sample App.

Tuesday Oct 01, 2013

OBIEE - APEX integration

(in via Lia)

We received a mail recently inquiring about the integration of OBIEE with APEX. It looks like earlier versions contained a documented integration path between the two, which in version 11g seems to be missing. This is what I received regarding that topic:

In OBIEE 11g, we do not have direct support for an OBIEE/APEX integration, and an Enhancement Request was raised:

There is an existing KM Doc for the older version:
Oracle BI and Oracle Apex (Application Express) interoperability and navigation. (Doc ID 748896.1)

It may be possible to utilize Action Frameworks as documented here: Action Framework:

As this integration is not documented, this would be outside of Oracle Support scope, and would require Oracle Consulting 's assistance (a chargeable service).  So, you need to contact Oracle Consultancy or ask directly in the OBIEE Community to see if someone has implemented something similar.


Web findings:

I ran a quick search on google for OBIEE APEX integration and found these:

Thursday Sep 26, 2013

Troubleshooting the Web Center Portal / OBIEE integration

(in via Julie)

Julie sent me her latest addition to the Knowledgebase: 

Troubleshooting the Integration of Oracle WebCenter Portal and Oracle Business Intelligence (Doc ID 1579858.1)

In her mail she explained:

"Having issues with embedding your OBIEE Reports in WebCenter Portal?
This troubleshooting document contains quick checks for you to test and solutions to issues that may arise.
There are details of log files to look at to help you identify the issue.
The integration uses SOAP connections and the impersonate abilities of OBIEE to ensure reports and data are secured correctly.
If this is not set up correctly, the integration will fail, steps of how to check this are also included in the note.

We hope to make the integration of the two a little easier for everyone.

Wednesday Sep 18, 2013

EPM / OBIEE certification general

(in via Ian)

We just had a series of post that talked about certification, and I hope that you liked the breakdown and the pointers that I did there.

Now, one of the issues that we face with certification and supported versions is that we live in a world of ever evolving and changing hard- and software. So while Oracle can test and clarify what versions work together, it might be the case that the same version soon is outdated or superseded by a later patch or product update. (We had a post about how to  read supported update versions earlier)

As Oracle does not know the patchdates, -versions or-contents of all third party products, and as we can not test products that do not exist yet, there usually is a time gap between the release of a patch and Oracle stating that this patch is supported/certified. And for legal reasons Oracle can not and will not announce the support of future versions.

As far as we CAN say anything towards third party patching, we have tried to get a few statements from Product Management.

Ian got a clarification in a  community thread for BI where Gerald wrote:

"We "test" the versions that are available at the time that we release, but we "support" much more than we certify and are documented.
If we test a base version of a 3rd party datasource and the 3rd party vendor releases a Service Pack/Patch/Release Update that addresses a product defect (functionality/security/other), we would not know about the 3rd party patching timeframe but would support the update because we tested the base version as well as cover it under the 'Generic ODBC support' (that we document).
We have tested the configuration, the configuration passed our test, we support higher releases, and service packs.
The Support team will address SR's on those configurations and file bugs where the defect is shown to occur with Oracle BI.
Although we support more than we document, we only document what we tested.

I also went out and spoke to Product Management if there was any input they could give us on the topic. Bill pointed me to the second Tab of the supported Platform matrices (EPM) that states:

"Oracle's Backward Compatibility Policy:
Oracle acknowledges and supports the backward compatibility assertions for platform software as provided by its vendor. Therefore when vendors assert backward compatibility, subsequent maintenance releases and service packs may be used. If an incompatibility is identified, Oracle will specify a patch release on which EPM System should be deployed (and remove the incompatible version from the supported matrix) or provide a maintenance release or service fix to the EPM System product software."

This does not only applyto Operating Systems, but all third party products that are used in combination with EPM.

I hope this sheds some light on Oracle policies and what can and can not be said about support of updates and patches. And of course I cannot finish this post without advertising our certification matrices again ; ) , in case you still have a question.

Tuesday Sep 17, 2013

OBIEE Charts & Graphs Not Displaying

(in via Tanya)

We have been advised that where Internet Explorer 8 and Adobe Flash 11.8.800.168 is being used, OBIEE Charts and Graphs fail to render and do not display.

Those environments using Adobe Flash version 168 should upgrade to version 174.  By upgrading to this latest version will resolve the issue.

For additional information as it comes to hand - stay tuned to:

 [Doc ID 1584676.1] OBIEE Charts &Graphs are Not Displaying on Machines with IE 8 & Adobe Flash Version 11.8.800.168

Wednesday Sep 11, 2013

EPM / OBIEE certification with Java 7

the final part 4 of our little series about compatibility will deal with :

  • Internet Explorer 10 compatibility
  • Windows 2008 support
  • Office 2013 compatibility
  • Java 7 support

So here we go

"Java 7 compatibility" 

Before we begin talking about Java compatibility, we need to understand a few specifics about our products and Java, that are a little more complex than e.g. the OS the products run on.

First of all, Java is more a technology than a product - there are multiple JDKs (Java Development Kits) and JREs (Java Runtime Environments) out from various vendors, and only specific parts of the EPM System and OBIEE make use of these in their server and client components.

One way to get into the topic is to check the download site for "Java 7" as it shows up in e.g a google search:
Here we get some of the common aliases that Java uses:
"Java software for your computer, or the Java Runtime Environment, is also referred to as the Java Runtime, Runtime Environment, Runtime, JRE, Java Virtual Machine, Virtual Machine, Java VM, JVM, VM, Java plug-in, Java plugin, Java add-on or Java download."

This makes answering the question "Is EPM (or OBIEE) compatible with Java 7" close to impossible.The question is simply not specific enough as an EPM Systems usually consist of a multitude of servers and clients, all running different parts of the System, and all of them in need of different aspects of Java.

A more specific question would need to include the version, the component, the OS and e.g the Application Server.

For example: "If our Essbase Administration Services Server runs on Oracle Weblogic 10.3.5 (11g R1) on Windows 2008 R2 (64-bit), can we install Oracle JRE 1.7.0_21 on that machine without a problem?". And the answer as it comes from the support matrix is - yes, this is a supported version (stated is: JRE Plug-in 1.7.0_07+).

(click to enlarge)

The additional information section of this also gives us an idea of what modules/parts of the EPM System actually make use of the JRE version mentioned, and we can work backwards from there to find out which parts actually do NOT make use of it and simply ignore it.

Another example: the Excel Add In and SmartView are not mentioned and therefore do not need or use the installed JRE on a client.

Likewise will the EAS Server ignore the installed JRE on the server box, as it simply does not use it, while the JDK that is used by weblogic 10.3.5 can only be of version 1.6.0_35+ (as of certification tab). So - yes, you can install the JRE 1.7.0_21 and will not run into trouble - as the EAS Server component does not use it anyway.

So much for the introduction. Java 7 seems not to be easy to tackle. But let us give it a shot:

EPM and Java 7

A search for "EPM Java 7" on KM gives us a good hit:

KM Doc "Java 7 Compatibility With Hyperion EPM Products (Doc ID 1546957.1)"
(last update August 13 2013)

This states:

"Currently Java 7 is not supported with any Hyperion EPM products, so it should not be upgraded to this release on EPM servers. Java version that is shipped by default with EPM System should be used."

This seems to be rather clear, but does not say anything about the JRE on the clients (where potentially nothing gets installed by the system, if we access EAS Console via a Web Browser).

So second stop - the certification tab - with the result:

(click to enlarge)

We see that no JRE is mentioned at all, but at least we now have an idea about the JDKs that we can choose from on the server side.

Next stop is the  compatibility matrix. We get the information as above on the "EPM System Basic Platform" Tab of the sheet. And see that indeed JRE Plug-in 1.7.0_07+ may be used on the client.

So - this is EPM pretty much covered. On to:

OBIEE and Java 7

A search on KM for "OBIEE Java 7" and for "OBIEE "Java 7"" does return a number of Documents but none of then appear helpful.

So second stop - compatibility matrices:

(click to enlarge)

in which we see the Oracle JDK 1.7.0_0.7 listed along with e.g HP 7.0.3- an indicator that Java 7 is on the list for this one


(click to enlarge)

again, we see a number of JDKs with a "7" in them (HP, IBM, Oracle) so based on this we can conclude that OBIEE is (at least partially) certified with Java 7.

Having said that - we better check back to the compatibility matrices, to see if we can find more details:

(click to enlarge)

Surprisingly enough we find that the only supported JRE version for the client part of OBIEE ( is 1.6.0_35+ !
So from a client perspective Java 7 is a no-go, while the server part seems to be fine with it.

General Certification Information

I would like to close today's post with a definite - maybe !

The question of Java 7 compatibility is simply not specific enough for a System like EPM or OBIEE. Some modules do support some brands and versions of Java 7 while others do not. I have tried to get you closer to an answer with this, but chances are, that your specific issue at hand may not correlate to what I outlined above.

My ideal post would have included a clear Yes or No answer to the Java 7 support question. Eventually I can only give you a starting point for your research, and an idea about the complexity of the system architecture.

Overall it can be said that the Java 7 issue is something that needs a closer look about the architecture in question, the versions used and what part/module of the software is touched.

So here is where you find the answers:

A word to the wise

Keep in mind, that not being in these lists does not necessary mean, that things do not work.
It just means that it has not been tested, is not certified, and Oracle does not say anything about it working or not, and therefore does not guarantee its behaviour.
Chances are - it might just work anyway, but do not come running if it does not.
Oh and - a lot of people post their findings in the comment section here or in the Communities - so make sure to check there for real-life experience.

Tuesday Sep 10, 2013

OBIEE and EPM search helpers are online

(in via Mel, Tara, Lia)

In order to make finding information easier, Oracle Support has created a series of what we call search helpers (aka Resolution Wizards, Task Assistant, Troubleshooting Assistant, Installation and Configuration Assistant or Integration Assistant depending on what it is each of them does : ) ).

One of the problems that our customers face when working with KM is digging up the information they need to overcome a problem.

This is rather easy when you have an error message to start with. Error messages are great for classifying the type of problem that you have, and you also instantly note if a KM Doc deals with your problem, or not.

So - what if you do not have an error message? There are many reasons for that. From How to questions, product configuration questions or any other proactive task (like - best backup practice etc.).

The wording people may use when they write a KM note, may simply not match how you would describe the issue (we see that on a daily basis where people search for "compatibility" while throughout KM "certification" is used) so it might be difficult for the search to match your issue with existing KM notes.

Would it not be nice if you could run through a kind of interactive checklist that filters down the available KM notes based on your input?

That's what the search helpers are.

They are in NO way related to this little chap

I would describe them as "hand picked, engineer selected, automatically updated, classifying filters to KM".

With the right search terms you can locate any KM Doc that they display. Alas - that is the trick! You do not need to come up with your own search terms. This is what the search helpers provide.

Now - where do you find them?

You can find them via the KM Doc 1378677.2 ( Resolution Wizard ). I have also put a list of available search helpers at the bottom of this post. As this list is constantly growing the question remains: how to keep track of these?

Good news: You do not need to.

The search helpers appear automatically when you log an SR.

(click to enlarge)

Notice in the above picture, that the search helper comes up as the first KM note offered during the SR logging process (step 2). As the helper is using JQuery for its content, loading the selections happens without opening a new KM Doc - all you see is already pre-loaded. It now offers a choice of search topics that it can assist with.

When following the selections in this one, it eventually give you a list of KM notes directly related to your issue.

(click to enlarge)

So - yay! 

Search helpers are created as another layer within MOS KM that tries to make information more accessible for you as a customer. Let us know what you think of them. We have a community thread about them ( here for OBIEE ) and are waiting for your feedback.

Oh, one last remark: search helpers are a work in progress and they do not exist for all our products yet. As we add more, you will encounter them more often, but for now the list below is all we have live.

List of KM search helpers (as of Sept 09.2013)

1545233.2 - Troubleshooting Assistant: Oracle Business Intelligence Enterprise Edition (OBIEE)
1560184.2 - Installation and Configuration Assistant for Oracle Business Intelligence (OBIEE)
1558400.2 - Integration Assistant with Oracle Business Intelligence (OBIEE)
1563079.2 - Server Related Issues - Task Assistant for Oracle Business Intelligence (OBIEE)
1558378.2 - Security/Access Control Assistant for Oracle Business Intelligence (OBIEE)
1562668.2 - Administration Task Assistant for Oracle Business Intelligence (OBIEE)
1562361.2 - Presentation Service Task Assistant with Oracle Business Intelligence (OBIEE)
1562934.2 - Delivers and Schedulers Task Assistant for Oracle Business Intelligence (OBIEE)

1550461.2 - Troubleshooting Assistant: Hyperion Financial Management Technical Issues 11.1x
1548628.2 - Task Assistant: Hyperion Financial Management 11.1.x
1566812.2 - Task Assistant: Hyperion Financial Management and Oracle Data Integrator Issues
1566505.2 - Task Assistant: Hyperion Financial Management and EPMA Issues
1553294.2 - Troubleshooting Assistant: Financial Data Quality Management (FDM)

Thursday Sep 05, 2013

OBIEE is the Final Regular Bundle Patch

(in via Ian)
In addition to the information we shared at the beginning of the week about OBIEE being available, we would like to inform you,

that is the Final Regular Bundle Patch and that

Error Correction Support in Product Life Cycle for OBIEE ends April 2014.

With the release of, the bi-monthly cadence of bundle patches for the OBIEE series will be suspended.We will continue to support the product and issue additional patches and updates as needed.

Please be aware that the Error Correction Support product life cycle for Oracle Business Intelligence Enterprise Edition and Oracle Business Intelligence Publisher  ends April 2014.

We are encouraging you to move to OBIEE

For more details on upgrading, please see the following documents on
My Oracle Support (

Tuesday Sep 03, 2013

EPM / OBIEE certification with MS Office 2013

Part 3 of our little series about compatibility will deal with :

  • Internet Explorer 10 compatibility
  • Windows 2008 support
  • Office 2013 compatibility
  • Java 7 support

So here we go

"Office 2013 compatibility" 

EPM and Office 2013

As searching the certification for SmartView did not bring back any results, I used a simple MOS search for "SmartView Office 2013" and instantly got the  KM Doc 1564743.1 back that states:

"SmartView is now independent of the EPM portfolio release schedule and has targeted Office 2013 support for later this summer in the next PSU release, (modified June 2013)"

Now - that seemed rather easy - so how about the other one?

OBIEE and Office 2013

For OBIEE the answer was more difficult to find via MOS.
A direct search for "OBIEE Office 2013" returned a series of documents, but none of them seemed directly related to the question at hand.

So what to do now? I fell back on the good old compatibility matrix. Lucky as I am, during that search a doc came up titled: "Oracle Business Intelligence Support Matrix - Product Compatibility Information (Doc ID 1526630.1)" which most likely would contain what I was looking for.

Having a closer look at that one, I found a link in it:

(click to enlarge)

Of course it would have been easier to simply use the certification tab again, as that one DOES actually include the compatibility for OBIEE with Office:

(click to enlarge)

Both ways are consistent in telling us:

Office 2013 is not yet supported by OBIEE (or by SmartView with OBIEE).

General Certification Information

So what did we learn by this? The compatibility matrix is always a way to find out about compatibility of products - next to a MOS search, the certification tab and the communities.The results might be more difficult to read and are hidden deep within technet and the documentation, but they do exist and provide answers.

So here are a few links that might come in handy when looking for certification information via platform matrices:

  • Links to all Fusion Middleware compatibility matrices can be found here
  • All EPM Compatibility matrices can be found here
  • (more specifically) the one for EPM 11.1.2.x is here.

And for Business Intelligence you find the compatibility matrix


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



« April 2014