Local language — Oracle Analytics

Oracle Analytics Cloud and Server

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

Local language

Received Response
71
Views
11
Comments
mmajdana1
mmajdana1 Rank 6 - Analytics Lead

Hi i am using  OBIEE 12.2.1.2.0

How can i set local language in OBIEE so my sort can be properly done, i need to use Croatian.

Can anyone help me?

«1

Answers

  • mmajdana1
    mmajdana1 Rank 6 - Analytics Lead

    I dont know if i understood it right, i put croatian in Features tab in Admin Tool, changed

    LOCALE = "croatian"; 

    SORT_ORDER_LOCALE = "croatian"; 

    SORT_TYPE = "binary"; 

    in NQSConfig.ini file and saved it then restarted BI components and nothing changed... stil english sort..

    Did I miss something??

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    On 'still english sort', can you provide details on what the column in question is, and what the sort order specified on that column is.

  • mmajdana1
    mmajdana1 Rank 6 - Analytics Lead

    @Robert Angel This column does not have any other column set as a sort order... so in my opinion sort should go alphabetically when i set ''sort ascending'' in OBIEE.

    Does database itself has to be set to a croatian , or I can override it somehow through OBIEE??

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    What you have should work  - have you shut down and restarted the server after changing the settings?

  • mmajdana1
    mmajdana1 Rank 6 - Analytics Lead

    I restarted BI components, i will now restart the server and let you know the result.. thx anyway...

  • mmajdana1
    mmajdana1 Rank 6 - Analytics Lead

    Still the same ... I am out of options... any advice would be appreciated

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Does this note apply to you; -

    "When the NLS_CHARACTERSET in the Oracle Database is set to a non-unicode derived code page, you must configure an additional metadata repository setting to make character sorting consistent between the Oracle Database and the Oracle BI Server.

    To modify the metadata repository when the underlying Oracle database NLS_CHARACTERSET is not unicode:

    1. In the Administration Tool, open the metadata repository.
    2. Expand the database object in the physical layer.
    3. Open the Connection Pool dialog Connection Scripts tab, and add the following new connection pool script:alter session set NLS_SORT = unicode_binary
    4. Save the repository, and restart the Oracle BI Server."
  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    See also; -

    14.6.8 Enabling Lexicographical Sorting

    Lexicographical sorting is the ability to sort data in alphabetical order. Most data sources support lexicographical sorting. However, if you notice that lexicographical sorting is not working properly for a particular data source, then you can configure the Oracle BI Server to perform the sort rather than the back-end data source. To perform this configuration, ensure that ORDERBY_SUPPORTED is not selected in the Features tab of the Database dialog in the Administration Tool. See Oracle Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition for information about specifying database features.

    Note that disabling ORDERBY_SUPPORTED in the data source can have a very large performance impact, because consequently, many joins are not pushed down to the data source. In many cases, the performance impact is significant enough that ORDERBY_SUPPORTED can still be enabled in the data source, regardless of the impact on the lexicographical sorting functionality.

  • mmajdana1
    mmajdana1 Rank 6 - Analytics Lead

    Nothing helped... thx for effort but none of this works, il raise  SR for this because i cannot belive nothing helps..