OTBI Multi Language Support - Report not bringing back data when in different language

Max W

Summary:

When users who have a different language selected other than English runs a New Hire report, the report will bring back no data because of a string in the filter called "Hire".

Content (required):

When the language is in anything other than English, the report won't bring back information. One of the filters on the report is looking for an action Reason called "Hire" & "Rehire an employee". As the words are in English, should OTBI translate the filter from English to the desired language to find results, or because the filter is English, their language will not find the action reasons, and bring back data.

Version (include the version you are using, if applicable):

R13 22C

Code Snippet (add any code snippets that support your topic, if applicable):

Bhaskar Konar

Hi Max,

(@Max W)

Please find attached document which might be useful.

Can you please try the following?

Use Double Column to Create Language-Independent Filters:

Oracle Cloud applications store data in multiple languages. Hard-coding text string in a filter creates a problem with multi-lingual data. OTBI uses Double Column to support language-independent filtering. Double Column allows a column to have a ‘display’ column and ‘code’ column. ‘Display’ column displays data values for a column, e.g. female, male; and a ‘code’ column contains code values that are used independently across locales and languages, i.e. ‘F’ for female and ‘W’ for male. When a Double Column code filter is enabled, the report can be created once and the filter is automatically rendered in user’s local language without code change. OTBI subject area columns that are commonly used as filters have Double Column enabled in the repository. When you filter on a column that has Double Column enabled, you will see ‘Filter by xxxx Code’ option on the Edit Filter dialog box. More information on Double Column can be found in OBIEE documentation Understanding the Double Column: https://docs.oracle.com/cd/E28280_01/bi.1111/e10544/analyses.htm#BIEUG10375

OTBI Multi Language Support - Oracle White Paper.pdf

Hope this help.

Cheers,

Raghavan p-Oracle

CC thread:

https://community.oracle.com/customerconnect/discussion/32819/otbi-multi-language-support

Max W

Hello @Bhaskar Konar

Thank you for your help. I've managed to fix the solution with your help. That document gave me some extra knowledge. Appreciate it a lot!

Bhaskar Konar

Hi Max

(@Max W)

Glad you are able to fix it and you liked it.

Cheers,