OBIEE Step by Step Guide

January 8, 2010

BI Publisher XLIFF and Report Localization

What is XLIFF?

XLIFF is XML Localization Interchange File Format. When an RTF template if created using MS Word, this RTF is translated to XLIFF so that the template is local agnostic i.e. the same template being applied across many locales. XLIFF is a standard format provided by localization providers.

 How does this come into play in BI publisher?

Rather than trying to recreate how this works, I will copy from the Oracle Documentation and let you interpret how this works. 

“Using BI Publisher’s XLIFF generation tool, you can generate the standard translation file of your RTF template. You can then translate this file (or send to a translation provider). Once translated, the file can be uploaded to the report definition under the appropriate locale setting so that at runtime the translated report will automatically be run for users selecting the corresponding locale.”

Extracted from Oracle BI Publisher’s Report Designer’s Guide. It can be found here.

Where do you set your locale settings in BI Publisher?

Once you login to BI Publisher,  click on “Preferences” on the upper right corner. Click on “General Properties” and you will see the “Report Locale” as one of your options.

Where is report locale being used and for what purposes?

As it refers in any other software, this is used for changing the format of your output. Ex: Number format, Date format which are quite different in each country and continent. 

Do we need a specific locale template for xml publisher to work in a particular locale?

I will quote Oracle’s documentation for this.

“A particular report must have an available template translation for the selected locale. If not, BI Publisher will apply a locale fallback logic to select the template.”

Thanks for your feedback……



Blog at