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