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?
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.