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!
Continue reading “OBIEE 12c 12.2.1.1 Now Generally Available! Upgrade it today!”
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.
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”
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.
Starting with Essbase 11.1.2.4, these features are no longer supported:
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)
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
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
Next, we’ll use Sample Sales Lite as an example.
Continue reading “OBIEE 11.1.1.7.141014 Limit Prompt Values Bug Workaround”
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…”.
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.
mondaybi.com 