You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. 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?
A.
The AggregationFunction property of NumberBalance should be set to FirstNonEmpty
B.
The AggregationFunction property of NumberBalance should be set to Sum
C.
The AggregationFunction property of NumberBalance should be set to ByAccount
D.
The AggregationFunction property of NumberBalance should be set to LastNonEmpty
Explanation:
EXAM TIP
Development and Enterprise editions of SSAS provide several functionssuch as LastChild, LastNonEmpty, and AverageOfChildrenthat 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).