nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Local language

mmajdana1

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?

Find more posts tagged with

Accepted answers

All comments

Robert Angel

See ->

https://docs.oracle.com/middleware/12212/biee/BIESG/GUID-15ED681D-DEE7-4AB4-A9B2-01A3A5F1757A.htm#BIESG1745

mmajdana1

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

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

@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

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

mmajdana1

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

mmajdana1

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

Robert Angel

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:

In the Administration Tool, open the metadata repository.
Expand the database object in the physical layer.
Open the Connection Pool dialog Connection Scripts tab, and add the following new connection pool script:alter session set NLS_SORT = unicode_binary
Save the repository, and restart the Oracle BI Server."

Robert Angel

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

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

Upcoming Event

Oracle AI World 2026
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…

Top Leaders