Posted by: michaelverzijl | 27/03/2012

OBI 11.1.1.6 – Export to Excel

20120529 – Solved by applying patch 14003822:
https://mverzijl.wordpress.com/2012/05/29/obiee-11-1-1-6-export-to-excel-solved/


OBI 11.1.1.6 is available since 1 month and currently we are installing this release by several clients.
During testing we found a nasty bug in exporting an analyses to Excel.

What’s happening?
We have a dashboard that has a very simple analyses:

When exporting this to Excel the result is:

The decimal separator is shown with a “.”, instead of a “,”
Therefore analyses don’t show a nice result in Excel as a Dutch system expects a “,” as a separator for decimal numbers.

Changing your locale setting in OBI doesn’t do the trick unfortunately..
Bug numbers 13886133 and 12931559 can be followed on MOS for fixes (hopefully soon because this is a show stopper for migrations to 11.1.1.6)

Advertisements

Responses

  1. […] A while ago I wrote a post on OBIEE 11.1.1.6 and exporting to Excel. You can find this post here. […]

  2. I’m facing this issue but only when exporting to Tab Delimited Format. If I export to Excel 2003 or 2007, values are presented with commas separating decimal places. When I export to Tab Delimited Format it replaces the comma with a dot. Do you know if there is any workaround/solution for this issue in 11.1.1.7 version?

    Thank you.
    Jaime


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Categories

%d bloggers like this: