Sort Order Locale
Administrators use this system setting to apply a locale setting to determine how content migrated from Oracle BI Enterprise Edition is sorted.
After you migrate content from your Oracle BI Enterprise Edition environment to Oracle Analytics, you may experience different sorting behaviors in analyses.
For example, if you look at a migrated analysis in Polish, the upper case and lower case letters might sort based on the Oracle Analytics default locale, not the original Oracle BI Enterprise Edition locale. To preserve the Oracle BI Enterprise Edition sort behavior in Oracle Analytics, change this setting to Polish.
Valid Values
- Arabic
- Chinese
- Chinese-traditional
- Croatian
- Czech
- Danish
- Dutch
- English-USA
- Finnish
- French
- German
- Greek
- Hebrew
- Hungarian
- Italian
- Japanese
- Korean
- Norwegian
- Polish
- Portuguese
- Portuguese-Brazilian
- Romanian
- Russian
- Slovak
- Spanish
- Swedish
- Thai
- Turkish
Apply Required
Yes.
Change Effective
After a few minutes.
Edition
Professional and Enterprise.
API Key and Values
API Key — DataQuerySortOrderLocale
ArabicChineseChinese-traditionalCroatianCzechDanishDutchEnglish-USAFinnishFrenchGermanGreekHebrewHungarianItalianJapaneseKoreanNorwegianPolishPortuguesePortuguese-BrazilianRomanianRussianSlovakSpanishSwedishThaiTurkish