get the app get the app       get the app       get the app


Question: 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?
1)The AggregationFunction property of CKQuantity should be set to Total.
2)The AggregationFunction property of CKQuantity should be set to Predict.
3)The AggregationFunction property of CKQuantity should be set to LastNonEmpty.
4)The AggregationFunction property of CKQuantity should be set to FirstEmpty.


Previous Next
Exam


Suggest other answer
Login to Discuss/suggest the answer...

Exam Exam: 70-448 MS SQL Server 2008, Business Intelligence





Recommended Learning for you

Close(X)
Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material