Culture and Collation

In AnalytiX-BI each data model is assigned a collation, which determines the default lexical rules to apply to string comparisons and, in certain cases (see DAYOFWEEKOFFSET), the calendar rules to use for certain functions.

AnalytiX-BI collations are composed by two parts, separated by underscore:

{culture identifier}_{case sensitivity modifier}

·         The culture identifier follows the .NET rules for culture identifiers. The name is a combination of an ISO 693 two-letter culture code associated with a language and an ISO 3166 two-letter subculture code associated with a country or region. Examples include jp-JP for Japanese (Japan) and en-US for English (United States). For more information refer to Culture names and Identifiers for .NET.

·         The case sensitivity modifier can be one of the two possibilities:

o    ci – which stands for case-insensitive

o    cs – which stands for case-sensitive

AnalytiX-BI sets the collation for all string columns in a data model to the system’s current culture, case-insensitive. This means that string comparisons will follow the lexical rules of the system’s culture and will be case-insensitive. In certain cases, it is possible to use the COLLATE keyword to override the default data model’s collation.

Note: it is currently not possible to modify the default data model’s collation, or the collation of individual string columns.