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…

Question

Options

• AAdd a Named Calculation to the SalesOrder table, using OrderTotal + CostTotal as the expression.
• BAdd a Named Calculation to the SalesOrder table, using OrderTotal, CostTotal as the expression.
• CAdd a Named Query to the DSV, using Select * From SalesOrder as the expression.
• DAdd a Named Calculation to the SalesOrder table, using OrderTotal - CostTotal as the expression.

• A
  3% (2)
• B
  8% (5)
• C
  18% (11)
• D
  71% (44)

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

No community discussion yet for this question.