OBIEE Patch 220.127.116.11.150120 ODBC driver returned an error
After patching to 18.104.22.168.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, 22.214.171.124.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.
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.