PrepAway - Latest Free Exam Questions & Answers

You need to create a measure named AccountBalance from the CurrentBalance column to display the closing accoun

You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a dimension
named Account and a time dimension named Time. You have a fact table that contains a
column named CurrentBalance. CurrentBalance contains the current account balance.
You need to create a measure named AccountBalance from the CurrentBalance column to
display the closing account balance for a time period.
What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Set the AggregationFunction property of AccountBalance to Sum.

B.
Set the AggregationFunction property of AccountBalance to ByAccount.

C.
Set the AggregationFunction property of AccountBalance to LastNonEmpty.

D.
Set the AggregationFunction property of AccountBalance to FirstNonEmpty.


Leave a Reply