An attribute represents a data column in a database table. Each entity has its own set of attributes and relations. In Wyn Enterprise, you can create an attribute by either binding to an existing field in the entity or writing a SQL query to generate one. 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.
Click the Add button next to the selected attribute.
In the Add Attribute dialog box that appears, enter the name of the new attribute.
Specify additional information about the new attribute such as whether it can accept null values and duplicate values using the Is Nullable and Is Unique properties.
If you are adding a new attribute by binding, select the Field option from the Binding section, and then select a data attribute in the provided list as shown.
If you want to add a new attribute through a SQL query, select the SQL Query option from the Binding section and enter the SQL statement to add the new attribute. The below query calculates the revenue by unit area.
Click the Validate button to verify the data binding or SQL query.
Finally, click the Add button to confirm.
A newly added attribute will appear in the list of attributes on the left. You can modify the properties of the new attribute in the Properties panel that appears on the right.
The following table describes the important properties of an attribute that you can set in the Data Model Designer.