70-448 · Question #315
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL…
The correct answer is D. The AggregationFunction property of NumberBalance should be set 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 a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL Server 2008. You work as the technical support. Now you receive an e-mail from your company CIO, in the e-mail, the CIO assigns a task to you. You use SQL Server 2008 Reporting Services (SSRS) to create a solution. There is a dimension named Number and a time dimension named Day. A column named PresentBalance is contained in a fact table. PresentBalance contains the current account balance. A measure named NumberBalance has to be created from the PresentBalance column. The NumberBalance is used to display the closing account balance for a time period. So what action should you perform?
Options
- AThe AggregationFunction property of NumberBalance should be set to FirstNonEmpty
- BThe AggregationFunction property of NumberBalance should be set to Sum
- CThe AggregationFunction property of NumberBalance should be set to ByAccount
- DThe AggregationFunction property of NumberBalance should be set to LastNonEmpty
How the community answered
(20 responses)- A5% (1)
- B5% (1)
- C15% (3)
- D75% (15)
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.