Language/Collation (Analysis Server Properties Dialog Box) (Analysis Services - Multidimensional Data)

Binary

Select this option to sort and compare data based on the bit patterns defined for each character. Binary sort order is case-sensitive, that is, lowercase precedes uppercase, and accent-sensitive. This is the fastest sorting order.

If this option is not selected, Analysis Services follows sorting and comparison rules as defined in dictionaries for the associated language or alphabet.

Note

If this option is selected, the Case-Sensitive, Accent-Sensitive, Kana-Sensitive, and Width-Sensitive options are disabled.

Case-Sensitive

Select this option to sort and compare data based on the dictionary rules provided for the associated language or alphabet, and to distinguish between uppercase and lowercase letters.

If this option is not selected, Analysis Services considers the uppercase and lowercase versions of letters to be equal. Analysis Services does not define whether lowercase letters sort lower or higher in relation to uppercase letters when Case-sensitive is not selected.

Kana-Sensitive

Select this option to sort and compare data based on the dictionary rules provided for the associated language or alphabet, and to distinguish between the two types of Japanese kana characters: Hiragana and Katakana.

If this option is not selected, Analysis Services considers Hiragana and Katakana characters to be equal.

Select the language for the server

Select the Windows language and culture to use as the default language for the Analysis Services instance.