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