PrepAway - Latest Free Exam Questions & Answers

Which value should you use?

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?

PrepAway - Latest Free Exam Questions & Answers

A.
LastNonEmpty

B.
FirstNonEmpty

C.
Count

D.
Sum


Leave a Reply