The latest version of OBIEE 12c is now available. 22.214.171.124 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!
Continue reading “OBIEE 12c 126.96.36.199 Now Generally Available! Upgrade it today!”
So I previously said that the last release which was 188.8.131.52.150120 was supposed to be the last patch for OBIEE. However, on the day of Pluto Fly By, Oracle released 184.108.40.206.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 220.127.116.11.150714, then I would probably not patch to this version. For more information on Oracle Support page, you can go here.
OBIEE Patch 18.104.22.168.150120 ODBC driver returned an error
After patching to 22.214.171.124.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, 126.96.36.199.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 188.8.131.52.150120 ODBC driver returned an error Cannot Function Ship Error”
EPM 184.108.40.206 Released!
Get the latest version here Oracle Software e-Delivery
And the newest EPM 220.127.116.11 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 18.104.22.168, these features are no longer supported:
- Oracle Essbase Integration Services, including Hybrid Analysis and Advanced Relational Access
- 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
- Oracle strongly recommends using the Essbase JAVA APIs. You can also use the Essbase C APIs.
Continue reading “EPM 22.214.171.124 Released! Essbase 126.96.36.199”
OBIEE BUNDLE PATCH 188.8.131.52.150120
The Patch is platform specific and is available for:
IBM AIX on POWER Systems (64-bit)
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 184.108.40.206.0, 220.127.116.11.1, 18.104.22.168.131017, 22.214.171.124.140114, 126.96.36.199.140225, 188.8.131.52.140415, 184.108.40.206.140527, 220.127.116.11.140715 and 18.104.22.168.141014.
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 22.214.171.124.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:
Continue reading “OBIEE Patch 126.96.36.199.150120 Bugs Fixed”
There’s a strange bug since 188.8.131.52.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
Next, we’ll use Sample Sales Lite as an example.
Continue reading “OBIEE 184.108.40.206.141014 Limit Prompt Values Bug Workaround”
OBIEE Patch 220.127.116.11.141014 ODBC driver returned an error
After patching to 18.104.22.168.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…”.
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.