[]
        
(Showing Draft Content)

Add an Attribute

An attribute represents a data column in a database table. Each entity in a data model consists of a set of attributes, which can be added while extracting the data through the Get Data button. For more information on data extraction, see the Create Cached Model article.

Important Properties

The following table describes the important properties of an attribute available in the Data Model Designer.

Property Name

Description

Name

The name of the attribute.

Is Nullable

Specifies whether the attribute can contain null values.

Is Unique

Specifies whether the attribute can accept duplicate values.

Contains TimeZone

Determines whether the DateTime attribute contains the local timezone values. You can set the property to the following values:

Contains: Detects timezone information in the DateTime attributes.

Not Contains: Ignores time zone information in the DateTime attributes.

UnSpecified: This value only appears when an old version of the data model is migrated to a new version and does not include the local timezone in the DateTime attribute.

This property is specifically used with the DateTime attributes where timezone is also included like DateTime offset.

Binding

The database object that the attribute represents.

Logical Data Type

The attribute data type. If there is an expression, the data type must match the data type of the expression.

Data Category

Gives visualization hints related to the attribute type when generating a smart scenario through the Visualization Wizard. Different data types have different possible values. For example, the string data type supports these values: Geography (Region), Image URL, or Image Binary. The numeric data type supports these values: Currency, Geography (Latitude), or Geography (Longitude).

Is Hidden

Indicates whether the attribute is hidden from end-users. When the data model is used in the report, hidden attributes are not displayed.