Adding a New Logical Column (Attribute)

In the Models list, select the model that you want to edit and then click Edit model button.
In the model editor that appears, in the Entities list on the left, select the entity to which you want to add an attribute.
In the Attributes list on the right, click Add. The Add Attribute wizard appears.
In the Add Attribute wizard, click the Related Entity selection.
In the list of existing attributes that appears, a white triangle indicates that you can expand the node to reveal related attributes. (A black triangle indicates that a node is expanded.)
Select the one that you want to use and click Next.
In the Name and Description boxes that appear, enter the name and description for the new attribute.
Click Finish. The new attribute appears in the Attributes list.
In the Model Editor toolbar, click the Save & Publish button to save the changes. The new logical column is available to report creators.

In the Models list, select the model that you want to edit and then click Edit model button.
In the model editor that appears, in the Entities list on the left, select the entity to which you want to add an attribute.
In the Attributes list on the right, click Add. The Add Attribute wizard appears.
In the Add Attribute wizard, click the Database Field selection.
In the list of existing columns that appears, select the one that you want to use and click Next.
In the Name and Description boxes that appear, enter the name and description for the new attribute.
Click Finish. The new attribute appears in the Attributes list.
In the Model Editor toolbar, click the Save & Publish button to save the changes. The new logical column is available to report creators.

In the Models list, select the model that you want to edit and then click Edit model button.
In the model editor that appears, in the Entities list on the left, select the entity to which you want to add an attribute.
In the Attributes list on the right, click Add. The Add Attribute wizard appears.
In the Add Attribute wizard, click the SQL Expression selection.
In the Name box that appears, enter the name for the new attribute. This value appears in the list of entities for the model.
In the Description box, enter a description that provides users with additional information about the attribute, such as when it is appropriate to use it.
In the Expression Definition box, define the expression for the logical column with a SQL expression that pulls the data that you want.
Note: The syntax to use for expressions is T-SQL for SQL data sources or PL-SQL for Oracle data sources.
Check your query using the commands above the preview box.
- Validate verifies the expression and displays any errors it finds in red at the top of the dialog.
- Preview Schema populates a table with information pulled by the expression (column name, size, data type, and is nullable).
- Preview Data populates a table with a sampling of the data pulled by the expression.
Click Finish. The new attribute appears in the Attributes list.
In the Model Editor toolbar, click the Save & Publish button to save the changes. The new logical column is available to report creators.

To base a new attribute on a related entity

To base a new attribute on a database field

To create a new logical column (attribute)