Microsoft
70-448 · Question #15
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…
The correct answer is C. Set the AggregationFunction property of AccountBalance to LastNonEmpty. See the full explanation below for the reasoning.
Question
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?
Options
- ASet the AggregationFunction property of AccountBalance to Sum.
- BSet the AggregationFunction property of AccountBalance to ByAccount.
- CSet the AggregationFunction property of AccountBalance to LastNonEmpty.
- DSet the AggregationFunction property of AccountBalance to FirstNonEmpty.
How the community answered
(63 responses)- A2% (1)
- B5% (3)
- C84% (53)
- D10% (6)
Community Discussion
No community discussion yet for this question.