Export (0) Print
Expand All
Expand Minimize

Create/Edit Named Calculation Dialog Box (Analysis Services)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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.


Type the optional description of the named calculation.


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

© 2015 Microsoft