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?
A.
You should configure the AggregationFunction property of ProductBalance to Total.
B.
You should configure the AggregationFunction property of ProductBalance to ByProduct.
C.
You should configure the AggregationFunction property of ProductBalance to
LastNonEmpty.
D.
You should configure the AggregationFunction property of ProductBalance to FirstEmpty.
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).