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