You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.

Your data source view has a table named Products. The Products table contains the following three columns:

ProductKeyCostDiscount

The table also contains a named calculation column named PercentageCost.
You need to add another column named DiscountedCost that will display the value of Cost*Discount/100.

What should you do?

A.
Create a named calculation column named DiscountedCost with the following expression: Cost*Discount/100

B.
Create a named calculation column named DiscountedCost with the following expression:
Select Cost*Discount/100 from Products

C.
Convert the table to a named query with the following query definition: Select ProductKey, Cost, Discount, PercentageCost, Cost*Discount/100 as DiscountedCost from Products.

D.
Convert the table to a named query with the following query definition: Select ProductKey, Cost, Discount, PercentageCost from Products. Add a named calculation column named DiscountedCost with the following expression: Select Cost*Discount/100