collation-element-assl.md

title	description	ms.date	ms.service	ms.custom	ms.topic	ms.author	ms.reviewer	author
Collation Element (ASSL) | Microsoft Docs	Learn about the Collation property element in the Analysis Services Scripting Language (ASSL) schema.	10/31/2023	analysis-services	assl	reference	kfollis	kfollis	kfollis

Collation Element (ASSL)

Determines the collation used by the parent element.

Syntax

  
<Database> <!-- or one of the elements listed below in the Element Relationships table -->  
   ...  
   <Collation>...</Collation>  
   ...  
</Database>  

Element Characteristics

Characteristic	Description
Data type and length	String
Default value	None
Cardinality	0-1: Optional element that can occur once and only once.

Element Relationships

Relationship	Element
Parent elements	Cube, Database, DataItem, Dimension, MiningModel, MiningStructure
Child elements	None

Remarks

The Collation string consists of the locale identifier (LCID) and the comparison flag, separated by an underscore character. For example, Latin1_General_CI_AS is an acceptable string.

The elements that correspond to the parents of Collation in the Analysis Management Objects (AMO) object model are xref:Microsoft.AnalysisServices.Cube, xref:Microsoft.AnalysisServices.Database, xref:Microsoft.AnalysisServices.DataItem, xref:Microsoft.AnalysisServices.Dimension, xref:Microsoft.AnalysisServices.MiningModel, and xref:Microsoft.AnalysisServices.MiningStructure.

See Also

Properties (ASSL)