Attribute Snowflake Custom Rollup Properties Column Element
X-Ref:
- Ast Attribute Snowflake Custom Rollup Properties Column Node
- Ast Attribute Custom Rollup Properties Column Base Node
- Ast Attribute Column Base Node
Attributes
| Attribute | API Type | Default | Description |
|---|---|---|---|
| ColumnName | AstTableColumnBaseNode | This value specifies the relational database column that should be used as the basis for this Analysis Services dimension attribute column. This is a required reference to an existing definiton. | |
| Collation | String | Specifies the collation method used by the parent element. | |
| DataFormat | SsasDataFormat | Unknown | Specifies the formatting requirements of the DataItem element. The default setting is “none.” Allowed settings are Microsoft Excel formats and the string values TrimRight, TrimLeft, TrimAll, and TrimNone. |
| DataMimeType | SsasDataMimeType | None | Where applicable, specifies the Multipurpose Internet Mail Extensions (MIME) type of the data represented by the parent DataItem element. |
| InvalidXMLCharacterProcessing | SsasInvalidXmlCharacterProcessing | Preserve | Determines how invalid XML characters in the source data will be handled. Preserve retains the character, Remove deletes them, and Replace inserts a question mark (?) in the place of each invalid character. |
| NullProcessing | SsasNullProcessing | Automatic | Specifies how null values will be processed. The default setting is Automatic. Other allowed settings are Preserve (which preserves the null value), Error (which generates a null key error, UnknownMember (which generates an unknown member as well as a null conversion error) and ZeroOrBlank (which converts the null value to zero in numeric data items, and a blank string in string data items). |
| SsasDataType | SsasDataType | Inherited | This value specifies the type of the attribute column using the SQL Server Analysis Services (SSAS) type system. Note that this type may differ from the type of the column in the underlying data source or the value computed by the specified expression. In those cases, a type cast will automatically be performed on the basis of this property setting when the types are compatible. |
| Trimming | SsasTrimming | Right | Specifies how data from the data source will be trimmed. The default setting is Right. Other allowed settings are Left, LeftRight, and None. |
Collection Children
| Child | API Type | Description |
|---|---|---|
| <Annotations> <Annotation /> </Annotations> | AstAnnotationNode | This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. |