• Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:July 21, 2021
  • Reading time:5 mins read
You are currently viewing How to translate BI Report Output to other languages?
How to translate BI Report Output to other languages?

In this article we will look into how to translate the BI Output in languages other than English.

This is a guest post by Vivek Omar who is an Oracle HCM Cloud Lead with vast experience on the HCM Technical and Functional modules.

If the implementation spans multiple countries, then getting the output of the reports in their local language is the most common requirement. Ex Chinese/ Japanese/ French/ Spanish, etc.

The first step would be to Prepare the data model and Template (RTF) in the base language (English –US) and it would generate the output in the English language.

Next, Load sample XML file from data model to RTF template and download xliff file from it using the Translation

image 62 - How to translate BI Report Output to other languages?

The other way is to download the translation file from the BI Report properties.

image 67 - How to translate BI Report Output to other languages?

The xliff file (.xlf) when opened will look like below:

image 63 - How to translate BI Report Output to other languages?

We need to change the target language value as per our requirement in the xliff file. For French it would be FR, for Spanish, it would be es, etc.

image 64 - How to translate BI Report Output to other languages?

We need to provide actual translation of the wordings that are present in xliff file to the target language. We need to use google translate or any other tool to get the translation text for the target.

image 65 - How to translate BI Report Output to other languages?

After modification of xliff file we need to go to Report > Edit and click on Properties where template is present. You need to upload modified xliff file to LOCALE Option.

image 66 - How to translate BI Report Output to other languages?

In the bursting query, we need to fetch Locale from SQL as their preferred language. Use the below query.

 (select (select username from per_users where user_guid = level_value) username ,profile_option_value from fnd_profile_option_values where profile_option_id in ( select profile_option_id from fnd_profile_options_vl where profile_option_name like 'FND_LANGUAGE' ))Translation_Rec

We can join this query in the from clause and join with papf.person_number

Translation_Rec.username = papf.person_number

The above query will pull the default language setup for the user from user preferences. So, the users with English will be able to see the output in English Language and the users with the French language will be able to see the output in the French language.

Thank you Vivek Omar for contributing to Fusion HCM Knowledgebase. If anyone else is interested in sharing the content, please reach out to us using the contact/chat options.

If you like the content, please follow us on LinkedInFacebook, and Twitter to get updated with the latest content.