Posted by: michaelverzijl | 27/03/2012

OBI – Export to Excel

20120529 – Solved by applying patch 14003822:

OBI 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



  1. […] A while ago I wrote a post on OBIEE 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 version?

    Thank you.

Leave a Reply

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

You are commenting using your 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


%d bloggers like this: