OBIEE 12c 12.2.1.1 Now Generally Available! Upgrade it today!

The latest version of OBIEE 12c is now available. 12.2.1.1 is available by either inplace upgrade or a fresh new install. I always prefer fresh install and migrating. You can download this at Oracle and notice the installer updated on June 21, 2016. A kind reminder to upgrade your JDK and client tools as well!

obiee12.2.1.1 Downloads

Continue reading “OBIEE 12c 12.2.1.1 Now Generally Available! Upgrade it today!”

Advertisements

OBIEE 11.1.1.7.150714 Patch Released

So I previously said that the last release which was 11.1.1.7.150120 was supposed to be the last patch for OBIEE. However, on the day of Pluto Fly By, Oracle released 11.1.1.7.150714. Oracle only states that this patch only fixes a major bug for Oracle Business Intelligence Third Party with bug number 20247002. I searched for this bug and could not find relevant information.

If you are stable on 11.1.1.7.150714, then I would probably not patch to this version. For more information on Oracle Support page, you can go here.

OBIEE 11.1.1.7.150120 ODBC driver returned an error Cannot Function Ship Error

OBIEE Patch 11.1.1.7.150120 ODBC driver returned an error

After patching to 11.1.1.7.150120 it so happens that where Total Rows are used, there may be possibilities that you get “ODBC driver returned an error…..Cannot function ship the following expression…”.

Yes, 11.1.1.7.141014 also has the same problem described previously in this post here. Actually, a interim fix has been issued for a few weeks now but I wanted to do deep dive tests before I tell everyone that this works. It works!!!

Download the Patch 19599154 here. Alternatively, search in Oracle Support for Patch Number 19599154 Windows x64 yourself to get this patch. You have options of fixing 141014 or 150120.

For more details of the original bug issue, please view below.

Continue reading “OBIEE 11.1.1.7.150120 ODBC driver returned an error Cannot Function Ship Error”

EPM 11.1.2.4 Released! Essbase 11.1.2.4

EPM 11.1.2.4 Released!

Get the latest version here Oracle Software e-Delivery

And the newest EPM 11.1.2.4 documentation!

I do really wonder how Hybrid is doing. Is Hybrid official now? I went through documents, but it seems that it’s still not officially documented.

Essbase Features No Longer Supported

Starting with Essbase 11.1.2.4, these features are no longer supported:

  1. Oracle Essbase Integration Services, including Hybrid Analysis and Advanced Relational Access
  2. Many of the basic concepts of Hybrid Analysis and Advanced Relational Access have been folded into the functionality of XOLAP cubes in Oracle Essbase Studio.
    Visual Basic API
  3. Oracle strongly recommends using the Essbase JAVA APIs. You can also use the Essbase C APIs.
    Configuration settings:

    1. PRELOADALIASNAMESPACE
    2. PRELOADMEMBERNAMESPACE
    3. PRELOADUDANAMESPACE
    4. MAXACTIVEUPDATETRANSACTIONS
    5. MAXTOTALACTIVETRANSACTIONS

Continue reading “EPM 11.1.2.4 Released! Essbase 11.1.2.4”

OBIEE Patch 11.1.1.7.150120 Bugs Fixed

OBIEE BUNDLE PATCH 11.1.1.7.150120

The Patch is platform specific and is available for:

HP-UX Itanium
IBM AIX on POWER Systems (64-bit)
Linux x86
Linux x86-64
MS Windows (32-bit)
MS Windows (64-bit)
Oracle Solaris on SPARC (64-bit)
Oracle Solaris on x86-64 (64-bit)

This patch set is available for Oracle Business Intelligence Enterprise Edition 11.1.1.7.0, 11.1.1.7.1, 11.1.1.7.131017, 11.1.1.7.140114, 11.1.1.7.140225, 11.1.1.7.140415, 11.1.1.7.140527, 11.1.1.7.140715 and 11.1.1.7.141014.

This is provided as single Bundle Patch 20124371 and is comprised of the following:

Patch 16913445 – 1 of 8 Oracle BI Installer (BIINST)
Patch 18841070 – 2 of 8 Oracle BI Publisher (BIP)
Patch 18657616 – 3 of 8 EPM Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
Patch 18841084 – 4 of 8 Oracle BI Server (BIS)
Patch 18841078 – 5 of 6 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 18841089 – 8 of 8 Oracle BI Platform Client Installers and MapViewer

NOTE: Also required to be downloaded:

Patch 16569379 – Dynamic Monitoring Service patch

Patch 18277370 – MS IE11 Environment Patch

Bugs fixes

Continue reading “OBIEE Patch 11.1.1.7.150120 Bugs Fixed”

OBIEE 11.1.1.7.141014 Limit Prompt Values Bug Workaround

There’s a strange bug since 11.1.1.7.140715 which is when you want to limit prompt values by another prompt, the All Column Values default selection gets reverted to — Select Value–. Here’s what happens and the workaround to fix it.

Lets start by creating a Dashboard Prompt

Create OBIEE Prompt

Next, we’ll use Sample Sales Lite as an example.

OBIEE-Limit-Prompt-Bug-010

Continue reading “OBIEE 11.1.1.7.141014 Limit Prompt Values Bug Workaround”

OBIEE 11.1.1.7.141014 ODBC driver returned an error Cannot Function Ship Error

OBIEE Patch 11.1.1.7.141014 ODBC driver returned an error

After patching to 11.1.1.7.141014 it so happens that where Total Rows are used, there may be possibilities that you get “ODBC driver returned an error…..Cannot function ship the following expression…”.

Error_Message

The way to fix it is to edit the fact columns and change the “Aggregate Rule (Total Rows)” to “Sum” instead of Default. The strange thing is that the first fact column can be left as default from my current observations. Hope this helps everyone who encounter this error.

Update 25-November-2014: For row totals, when percentage is present, changing to SUM will cause percentage to add up which is wrong. Temporarily may need to change report based aggregation methodology to none so that incorrect figures are not displayed. I am still working on how to fix this issue.