OBIEE Print Dashboard Page PDF without Prompts

By default, OBIEE does not allow you to print PDF without the prompts. The best workaround is to create a custom button using javascript which points to a hidden dashboard page made for printing. Then we can disable the print button in the dashboard and just use the custom javascript button for printing.

Continue reading “OBIEE Print Dashboard Page PDF without Prompts”

Advertisements

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”

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.

OBIEE 11.1.1.7.1 Bugs fixed / to be fixed now or 11.1.1.9 or 12c

I am going to go through a few important SR’s I have raised in the past few months and majority will have enhancements made by Oracle.

The reason why I’m writing this is because I’m hoping other could avoid these bugs if they come across it.

UNABLE TO SHOW TEXT MEASURES IN OBIEE FROM ESSBASE DATASOURCE

I would like to first give an update from my previous blog on Creating Text Entry in Essbase when I said there’s a bug when trying to read text entries from OBIEE. Recently, Dev team replied to have this fixed in 11.1.1.9 which is coming soon. However, there will be a three restrictions as follows (notice it says 11.1.1.8, this should be 11.1.1.9) (Bug 17515163):

Bug17515163

RELEASE NOTES:
  
This trans contains essbase text measure support feature. There are following three restrictions.
1)Essbase text measure member can only be defined on Measure dimension.
2)User need to manually mark the varchar data type in rpd physical layer for text measure.
3)The text measure can be supported only for flat cube model.

I would understand that the text member will need to be defined on a Measure dimension but point 2 and 3 doesn’t really make sense. This means a manual edit will be needed to mark as varchar data type. Moreover, flattening a cube isn’t a best practice. I guess we’ll have to make another suggestion to Oracle.

Continue reading “OBIEE 11.1.1.7.1 Bugs fixed / to be fixed now or 11.1.1.9 or 12c”

OBIEE Patch 11.1.1.7.141014 Bugs Fixed

OBIEE BUNDLE PATCH 11.1.1.7.141014

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.140415,
11.1.1.7.140527 and 11.1.1.7.140715.

This is provided as Single Bundle Patch 19261194 and is comprised of the following:

  • Patch 16913445 – Patch 11.1.1.7.141014 (1 of 8) Oracle Business Intelligence Installer (BIINST)
  • Patch 19190053 – Patch 11.1.1.7.141014 (2 of 8) Oracle Business Intelligence Publisher (BIP)
  • Patch 18657616 – Patch 11.1.1.7.141014 (3 of 8) Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
  • Patch 19190025 – Patch 11.1.1.7.141014 (4 of 8) Oracle Business Intelligence Server (BIS)
  • Patch 19190010 – Patch 11.1.1.7.141014 (5 of 8) Oracle Business Intelligence Presentation Services (BIPS)
  • Patch 17300045 – Patch 11.1.1.7.141014 (6 of 8) Oracle Real-Time Decisions (RTD)
  • Patch 16997936 – Patch 11.1.1.7.141014 (7 of 8) Oracle Business Intelligence ADF Components (BIADFCOMPS)
  • Patch 19190111 – Patch 11.1.1.7.141014 (8 of 8) Oracle Business Intelligence 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.141014 Bugs Fixed”