Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
561
Views
5
Comments
Max W
Max W Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence

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):


Tagged:

Answers

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics Strategist

    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



    Hope this help.

    Cheers,

  • Raghavan p-Oracle
    Raghavan p-Oracle Rank 5 - Community Champion

    CC thread:


  • Max W
    Max W Rank 3 - Community Apprentice

    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
    Bhaskar Konar Rank 8 - Analytics Strategist

    Hi Max

    (@Max W)

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

    Cheers,

  • Alexandre Chea-Oracle
    Alexandre Chea-Oracle Rank 1 - Community Starter

    Hi there,

    I have the same issue when trying to use a report with a criterion on the Inventory Transaction Type to have only the "Work in Process Material Issue" transactions.

    I don't understand how I can enable that double column feature, I can't see anything in the OTBI for it.

    Can someone help please?

    Thanks!

    Alex