Your company network includes a SQL Server 2008 R2 database server with the SQL
Server 2008 Analysis Services (SSAS) role enabled.
You design a cube named Materials with a measure group named MaterialsInventory. This
group has a measure, QuantityOnHand, which shows the total stock in inventory for the
company by time.
You need to determine the inventory at the end of a quarter.
What should you do?

A.
Define the MaterialsInventory group as a semi-additive measure group.

B.
Define the MaterialsInventory group as an additive measure group.

C.
Define the QuantityOnHand measure as an additive measure.

D.
Define the QuantityOnHand measure as a semi-additive measure.

Explanation: