You work as a database administrator for Abc.com. You are currently creating a SQL Server 2008 Analysis Services (SSAS) method for Abc.com. The solution contains a dimension named CKProducts and a time dimension named CKTimer. Abc has a fact table that has a field named Quantity. You need to develop a measure named CKQuantity from the Quantity field order to display the number of products for certain times. What should you do?

Question

TuteeHUB · Accepted Answer

The AggregationFunction property of CKQuantity should be set to FirstEmpty.

TuteeHUB · Answer

The AggregationFunction property of CKQuantity should be set to Total.

TuteeHUB · Answer

The AggregationFunction property of CKQuantity should be set to Predict.

TuteeHUB · Answer

The AggregationFunction property of CKQuantity should be set to LastNonEmpty.

1.	You work as a database administrator for Abc.com. You are currently creating a SQL Server 2008 Analysis Services (SSAS) method for Abc.com. The solution contains a dimension named CKProducts and a time dimension named CKTimer. Abc has a fact table that has a field named Quantity. You need to develop a measure named CKQuantity from the Quantity field order to display the number of products for certain times. What should you do?
A.	The AggregationFunction property of CKQuantity should be set to Total.
B.	The AggregationFunction property of CKQuantity should be set to Predict.
C.	The AggregationFunction property of CKQuantity should be set to LastNonEmpty.
D.	The AggregationFunction property of CKQuantity should be set to FirstEmpty.
Answer» D. The AggregationFunction property of CKQuantity should be set to FirstEmpty.

Discussion

No Comment Found

Related MCQs

Reply to Comment