SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Analysis Services - Multidimensional Data
Technical Reference
Feature Reference
Analysis Services F1 Help (Analysis Services - Multidimensional Data)
Analysis Services Designers and Dialog Boxes (Analysis Services - Multidimensional Data)
Add Cube Dimension Dialog Box (Analysis Services - Multidimensional Data)
Add Reference Dialog Box (Analysis Services - Multidimensional Data)
Add Table Dialog Box (Analysis Services - Multidimensional Data)
Add/Remove Tables Dialog Box (Analysis Services - Multidimensional Data)
Analysis Server Properties Dialog Box (Analysis Services - Multidimensional Data)
Assembly Properties Dialog Box (Analysis Services - Multidimensional Data)
Assign Aggregation Design Dialog Box (Analysis Services - Multidimensional Data)
Attribute Data Translation Dialog Box (Analysis Services - Multidimensional Data)
Backup Database Dialog Box (Analysis Services - Multidimensional Data)
Browse Data Source Dialog Box (Analysis Services - Multidimensional Data)
Browse Data Source View Dialog Box (Analysis Services - Multidimensional Data)
Browse for Remote Folder Dialog Box (Analysis Services - Multidimensional Data)
Calculated Member Builder Dialog Box (Analysis Services - Multidimensional Data)
Calculation Properties Dialog Box (Analysis Services - Multidimensional Data)
Change Settings Dialog Box (Analysis Services - Multidimensional Data)
Connection Manager Dialog Box (Analysis Services - Multidimensional Data)
Create Attribute Relationship and Edit Attribute Relationship Dialog Boxes (Attribute Relationship Designer Tab, Dimension Designer) (Analysis Services - Multidimensional Data)
Create/Edit Named Calculation Dialog Box (Analysis Services)
Create/Edit Named Query Dialog Box (Analysis Services - Multidimensional Data)
Create/Edit Relationship Dialog Box (Analysis Services - Multidimensional Data)
Create Polling Query Dialog Box (Analysis Services - Multidimensional Data)
Create Processing Query Dialog Box (Analysis Services - Multidimensional Data)
Cube Designer (Analysis Services - Multidimensional Data)
Cube Properties Dialog Box (Analysis Services - Multidimensional Data)
Data Exploration Options Dialog Box (Analysis Services - Data Mining)
Data Sample Viewer Dialog Box (Analysis Services - Multidimensional Data)
Data Source Designer Dialog Box (Analysis Services)
Data Source Properties Dialog Box (Analysis Services - Multidimensional Data)
Data Source View Designer (Analysis Services - Multidimensional Data)
Data Source View Properties Dialog Box (Analysis Services - Multidimensional Data)
Database Designer (Analysis Services - Multidimensional Data)
Database Properties Dialog Box (Analysis Services - Multidimensional Data)
Define Relationship Dialog Box (Analysis Services - Multidimensional Data)
Delete objects and files Dialog Box (Analysis Services)
Dimension Designer (Analysis Services - Multidimensional Data)
Dimension Properties Dialog Box (Analysis Services - Multidimensional Data)
Dismiss Warning Dialog Box (Analysis Services - Multidimensional Data)
Analysis Services Duplicate Security Role Dialog Box (Analysis Services - Multidimensional Data)
Enable/Disable Writeback Dialog Box (Analysis Services - Multidimensional Data)
Explore Data Dialog Box (Analysis Services - Multidimensional Data)
Filter Members Dialog Box (Analysis Services - Multidimensional Data)
Find Table Dialog Box (Analysis Services - Multidimensional Data)
Generate Named Query Dialog Box (Analysis Services - Multidimensional Data)
Impact Analysis Dialog Box (Analysis Services - Multidimensional Data)
Impersonation Information Dialog Box (Analysis Services - Multidimensional Data)
Incremental Update Dialog Box (Analysis Services - Multidimensional Data)
Key Columns Dialog Box (Analysis Services - Multidimensional Data)
Level Naming Template Dialog Box (Analysis Services - Multidimensional Data)
Locate Database Files Dialog Box (Analysis Services - Multidimensional Data)
MDX Builder Dialog Box (Analysis Services - Multidimensional Data)
MDX Query Editor (Analysis Services - Multidimensional Data)
Measure Group Bindings Dialog Box (Analysis Services - Multidimensional Data)
Merge Partition Dialog Box (Analysis Services - Multidimensional Data)
New Database Dialog Box (Analysis Services)
New Measure Dialog Box (Analysis Services - Multidimensional Data)
New Measure Group Dialog Box (Cube Designer)
Object Binding Dialog Box
Partition Properties Dialog Box (SSMS)
Partition Source Dialog Box (Analysis Services - Multidimensional Data)
Process Dialog Box (Analysis Services - Multidimensional Data)
Process Progress Dialog Box (Analysis Services - Multidimensional Data)
Refresh Data Source View Dialog Box
Register Server Assembly Dialog Box (Analysis Services - Multidimensional Data)
Relational Objects Dialog Box (Analysis Services - Multidimensional Data)
Remote Partitions - Advanced Settings Dialog Box (Analysis Services - Multidimensional Data)
Rename Instance Dialog Box (Analysis Services)
Replace Table with Other Table Dialog Box
Restore Database Dialog Box (Analysis Services - Multidimensional Data)
Role Designer (Analysis Services - Multidimensional Data)
Save File As Dialog Box (Analysis Services - Multidimensional Data)
Security Context Dialog Box (Analysis Services - Multidimensional Data)
Select Language Dialog Box (Analysis Services - Multidimensional Data)
Select Parent Member Dialog Box (Analysis Services - Multidimensional Data)
Show Table Dialog Box (Analysis Services - Multidimensional Data)
Storage Options Dialog Box (Analysis Services - Multidimensional Data)
Storage Settings Dialog Box (Analysis Services - Multidimensional Data)
User Selection Dialog Box (Analysis Services - Multidimensional Data)
View Details Dialog Box (Analysis Services - Multidimensional Data)
XMLA Query Editor (Analysis Services - Multidimensional Data)
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

Create/Edit Named Calculation Dialog Box (Analysis Services)

Use the Create/Edit Named Calculation dialog box in Business Intelligence Development Studio 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:

Copy 
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.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.