Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Local language
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?
Answers
-
-
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??
0 -
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.
0 -
@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??
0 -
What you have should work - have you shut down and restarted the server after changing the settings?
0 -
I restarted BI components, i will now restart the server and let you know the result.. thx anyway...
0 -
Still the same ... I am out of options... any advice would be appreciated
0 -
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."
0 -
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.
0 -
Nothing helped... thx for effort but none of this works, il raise SR for this because i cannot belive nothing helps..
0