(Showing Draft Content)

Add an Attribute

An attribute represents a data column in a database table. You can add a new attribute once an entity is selected. This article describes the steps to add an attribute in a data model and its important properties. For more information, refer to the following sections.

Add an Attribute

  1. To add a new attribute, in the model editor, select an entity, for which you want to add a new attribute, and click the Add button in the Attributes section.

    Add an attribute in the model editor

    Note that the Properties pane automatically expands on the right of the workspace.

  2. Enter the name and description for the new attribute.

    Add an attribute in the model editor

  3. In the Attribute Type field, select the attribute source type - database field, related entity, or SQL expression.

    • When you select the Database Field option, select the required field from the provided list.

    • When you select the Related Entity option, select the required field from the provided list of related entities.

    • When you select the SQL Expression option, enter the SQL expression definition field content. This option supports validation and preview.

    The following example adds an attribute by binding to an existing field of the entity, such as 'Description'.

    Add an attribute in the model editor

  4. Click the Add button. A newly added attribute will appear in the list of attributes of the data model's entity.

    Add an attribute in the model editor

Important Properties

The following table describes the important properties of an attribute that you can set in the Data Model Designer.

Property Name



The name of the attribute.


A description of the attribute that appears as tooltip text when a user hovers the pointer over the attribute.


A unique identifier for the attribute. Used internally by the system.


The database object that the attribute represents.

Data Type

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


The .NET Framework format string used to format the field.


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

Discourage Grouping

Indicates whether the client application organizes users into groups by this attribute. It is recommended to set Grouping not encouraged for attributes with unique values ​​(e.g., phone numbers).

Is Aggregate

Indicates whether the attribute is aggregated.


Sets whether the attribute can be nullable.

Support Blank Values

Indicates whether the attribute value can be empty.

Support Null Values

Sets whether the attribute supports null values.

Value Selection

Determines how to display field values ​​in the filter and parameter editor. You can select from three options: None, Dropdown, and List. The default value is None and it requires user input. The Dropdown option displays data values ​​in a drop-down list. The List option allows displaying more values than the ones displayed in the Dropdown option. If Is Aggregate is set to Yes, then ignore this attribute.