You have a SQL Server 2008 R2 Analysis Services (SSAS) solution.
You add a new Data Source View (DSV) to the solution. The DSV includes a SalesOrder
table with columns for OrderTotal and CostTotal.
You need to derive the profit for each order without modifying the underlying data.
What should you do?
A.
Add a Named Calculation to the SalesOrder table, using OrderTotal + CostTotal as the
expression.
B.
Add a Named Calculation to the SalesOrder table, using OrderTotal, CostTotal as the
expression.
C.
Add a Named Query to the DSV, using Select * From SalesOrder as the expression.
D.
Add a Named Calculation to the SalesOrder table, using OrderTotal – CostTotal as the
expression.
Explanation:
Note: A named calculation is a SQL expression represented as a calculated column. This
expression appears and behaves as a column in the table. A named calculation lets you
extend the relational schema of existing tables or views in a data source view without
modifying the tables or views in the underlying data source. For example, a common
calculated value derived from the columns of a fact table can be expressed as a single
named calculation in the data source view, instead of modifying the underlying database
table or creating a view in the underlying database.
A named calculation can also be used in place of calculated member in each cube based on
the data source view. Named calculations are calculated during processing whereas
calculated members are calculated at query time.
A named calculation is also frequently used to construct a user friendly name for a
dimension member.Define Named Calculations in a Data Source View (Analysis Services)