Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Collation Element
Collapse the table of content
Expand the table of content

Collation Element (ASSL)

Determines the collation used by the parent element.

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

Characteristic Description

Data type and length


Default value



0-1: Optional element that can occur once and only once.

Relationship Element

Parent elements

Cube, Database, DataItem, Dimension, MiningModel, MiningStructure

Child elements


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 Cube, Database, DataItem, Dimension, MiningModel, and MiningStructure.

Community Additions

© 2015 Microsoft