EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB31179: Sorting logic for the Analytical Engine in MicroStrategy


Community Admin

• Strategy


This article notes how Sorting logic works in MicroStrategy

Sorting Logic in Strategy - Locale Dependent Sorting:
In Strategy, Locale Dependent Sorting has been introduced to solve problems with different machines doing the sorting in different manners. The Strategy Engine uses the ICU (International Components for Unicode) libraries for collation, across all products.  As these libraries are standard across all platforms, the sorting results and rules are unified across different platforms as well.
 
ICU implements the Unicode Collation Algorithm, which is a multi-level sort. The rules are as follows:

  1. If there are any differences in base letters, this difference determines the sort result order.
  2. Otherwise, if there are any differences in accents, this is the next factor that affects the sort order.
  3. Otherwise, if there are any differences in case, this is the next factor that affects sort order.
  4. Otherwise, if there are any differences in punctuation, this affects the sorted results.

   

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
LOCALE TYPEPURPOSESETSelection LocaleDetermines who gets what publicationAt the publication levelExecution LocaleDetermines formatting for objects (such as system dates)At the document levelRECIPIENTLOCALESERVICE RECEIVEDAniEnglishPublicationARobertoSpanishPublicationBAndreaPortuguesePublicationCRECIPIENTLOCALESYSTEM DATE FORMATAniEnglish06/30/2006RobertoSpanish30-06-2005AndreaPortuguese2005-30-06 a--b a  b a  b a b a b a^b a!b a_b a#b a--b a$b a!b a%b a?b a&b a(b a(b a)b a)b a@b a*b a*b a/b a/b a?b a\\b a@b a&b a\\b a#b a^b a%b a_b a~`b a~`b a$b ab ab

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
  
Users can refer to the following links for additional information related to collation and ICU sorting:
Collation:    http://en.wikipedia.org/wiki/Collation
ICU:            http://site.icu-project.org/home
                   http://en.wikipedia.org/wiki/ICU
 
The following image shows the ascending sort order of the first 128 ASCII characters, when the locale is EN-US using the new ICU sort logic in Strategy Desktop 9.0. Users should note the following:

  1. The number beside each character is the decimal ASCII code for that character.
  2. Some characters cannot be displayed, users should refer to the ASCII code for this reference.
  3. The relationship between the characters in the first 28 rows is EQUAL. (Characters numbered as 0~8, 14~31, 127) - i.e the characters are considered "equal" to each other. So the final sort order on the report is dependent on the order in which the characters are retrieved from warehouse.
  4. The actual sort order may defer slightly from the result in the picture below, depending on the user's locale.

 
 

ka04W000000OhTkQAK_0EM440000002ELd.jpeg

Specific differences between the system level sort order in the Strategy Intelligence Server when compared to Windows sorting are as follows:

  1. Each Strategy user has a locale associated with their user session.
  2. Display sorts for report and document results are performed using the collation associated with the users locale in Strategy rather than the locale for the system for the client machine outside of Strategy.
  3. By using the Unicode Collation Algorithm, users will see consistent sorting as per their locale setting no matter what the underlying operating system platform used for the Strategy Intelligence Server is (Solaris, Linux etc) , or the client used for viewing the report data (Strategy Web, Desktop etc) or any other environment variable.
  4. Unfortunately as a result of using to the new ICU libraries, there is no way to provide the same sort order as Windows since this was operating system dependent, and the ICU libraries use their own set of collation maps.

 


Comment

0 comments

Details

Knowledge Article

Published:

May 17, 2017

Last Updated:

May 17, 2017