How to: Add, Modify, or Delete an Expression (Model Designer)

SQL Server 2008 R2

You can add expressions to folders and entities within Model Designer.

To add an expression

  1. In the Tree view, select the model item.

  2. On the Reporting Model menu, click New Expression.

  3. In the Define Formula dialog box, build your expression, and then click OK.

  4. In the Detail view, right-click the new expression and then click Rename.

  5. Type a name for your expression.

  6. In the Properties area, assign the properties that you want to apply to this field.

To modify an expression

  1. In the Detail view, click the expression that you want to modify.

  2. In the Properties area, click in the Expression box, and then click the Expression button.

  3. Modify the expression and then click OK.

To delete an expression

  • In the Detail view, right-click the expression and then click Delete.

Community Additions

ADD
Show: