Tuesday, July 24, 2012

Charts and Graphs stop displaying after 11.1.6.2 BP1 Upgrade

I was very excited to see that Oracle released the 11.1.1.6.2. BP1 patch for OBIEE. And I had the opportunity to install the patches to fix some bugs I had seen in one of our environments. After the upgrade some of out charts and graphs stopped displaying. Man two steps forward one step back....Took a stroll through Oracle Support and found out that there is a extra step some user have to do if they are using custom styles/skins. More in on steps at Oracle support search for Doc ID 1474605.1. Below is a snapshot of the steps to fix the issues taken directly from the Oracle doc:

Section 6: Post-Installation Instructions

-----------------------------------------

Section 6.1: Copying BIChart.swf To Custom Directories

The Oracle white paper "Customizing Oracle Business Intelligence Enterprise Edition 11g" describes how to customize BI Presentation Services by storing custom skins, styles, and messages in a custom directory.

If the BI System has been customized as described in the white paper and custom skins are stored in one or more custom directories, follow the additional instructions below to complete the 11.1.1.6.2 BP1 patchset installation:
  1. Go to the following directory:
    <Oracle BI Home>\bifoundation\web\app\res\sk_blafp\dvt
  2. Verify that the BIChart.swf file in that directory:
       - has a size of 457KB (466,944 bytes)
       - has a date of 6/4/2012
  3. Copy the BIChart.swf file to each custom directory in the BI System, replacing the existing file of that name:
    For example, on Windows, you might copy the BIChart.swf into the following custom directory:
       c:\prod_mwhome\Oracle_BI1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\analyticsRes\sk_mylookandfeel\dvt
  4. Stop and restart the BI Presentation Services system components.

  5. Clear the browser cache.

Issues with "Hide Column" Feature in OBI 11.1.1.6.1

There a issue in OBIEE 11.1.1.6.1 release around using the "hide" column feature, issue was when you clicked to hide a column it hid the one beside it. As in lets say you have three columns A/B/C you click to hide column B and it hides column A. There was a Bug logged as BUG 13963768. Found that the fix for this was in 11.1.1.6.2 BP1; more precisely the patch folder 6 of 7 in the list of 7. I have verified it is fixed in the .2 BP1 release. Love it when a patch actually fixes a issue...