Export (0) Print
Expand All
Expand Minimize

Create/Edit Named Calculation Dialog Box (Analysis Services)

Use the Create/Edit Named Calculation dialog box in SQL Server Data Tools (SSDT) to define or modify a named calculation for a table in a data source view. You can display the Create/Edit Named Calculation dialog box by:

  • Clicking New Named Calculation in the Toolbar pane of Data Source View Designer.

  • Right-clicking a table in either the Tables or Diagram pane of Data Source View Designer and selecting New Named Calculation.

  • Right-clicking the name of a named calculation in the Diagram pane of Data Source View Designer and selecting Edit Named Calculation.

Column Name

Type the name of the named calculation.

Description

Type the optional description of the named calculation.

Expression

Type a valid SQL expression that returns a scalar value. The expression is sent to the provider, and validated in the following expression:

SELECT <Table Name in Data Source>.* , <Expression> AS <Column Name> FROM <Table Name in Data Source>AS <Table Name in Data Source View>

The expression can contain references to other tables, by means of a sub-select statement. If the expression would require parentheses in a SELECT statement, the expression entered must be enclosed between parentheses.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft