70-448 · Question #87
You are developing a SQL Server 2008 Analysis Services (SSAS) method for Company.com. There is a dimension called Product and a time dimension called TestTimer in your solution. You own a fact table…
The correct answer is C. You should configure the AggregationFunction property of ProductBalance to LastNonEmpty. Development and Enterprise editions of SSAS provide several functions--such as LastChild, LastNonEmpty, and AverageOfChildren--that help you handle semiadditive measures. For example, LastNonEmpty will let you get the closing inventory balance for a given time period that is…
Question
You are developing a SQL Server 2008 Analysis Services (SSAS) method for Company.com. There is a dimension called Product and a time dimension called TestTimer in your solution. You own a fact table which includes a column called ProductBalance which includes the current account balance. You should make sure that you develop a measure called Test ProductBalance from the TestBalance column to show the closing account balance for some times. Which is the correct answer?
Options
- AYou should configure the AggregationFunction property of ProductBalance to Total.
- BYou should configure the AggregationFunction property of ProductBalance to ByProduct.
- CYou should configure the AggregationFunction property of ProductBalance to LastNonEmpty.
- DYou should configure the AggregationFunction property of ProductBalance to FirstEmpty.
How the community answered
(30 responses)- A13% (4)
- B10% (3)
- C73% (22)
- D3% (1)
Explanation
Development and Enterprise editions of SSAS provide several functions--such as LastChild, LastNonEmpty, and AverageOfChildren--that help you handle semiadditive measures. For example, LastNonEmpty will let you get the closing inventory balance for a given time period that is not empty. Although you can use custom MDX expressions to aggregate semiadditive measures, you will get better performance if you use these standard functions. for the complete list of standard aggregation functions, see the topic "Confi guring Measure Properties" in SQL Server 2008 Books online (see References).
Topics
Community Discussion
No community discussion yet for this question.