You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.
The project consists of a cube that contains the following objects:
A time dimension named DimTime that contains a hierarchy named Calendar. The first level of the hierarchy is named Year and the second level is named Quarter.
A dimension named DimProduct.
A fact table named FactInventory that stores the daily stock-in-hand measure for each product.
You need to set the AggregateFunction property to ensure that the cube displays the stock-in-hand measure for each product at the end of each quarter. Which value should you use?
A.
LastNonEmpty
B.
FirstNonEmpty
C.
Count
D.
Sum