A report author uses an OLAP cube to create a crosstab with Revenue as a measure, the Product line level in the rows, and the year members (2004-2007) in the columns. How can the report author efficiently determine the difference in revenue between the years 2005 and 2006?
A. Determine MUNs for the years 2005 and 2006, and then create an expression using the MUNs.
B. Create a new column as a query calculation, and create the expression [2006]-[2005].
C. Create a set of the 2005 and 2006 members and aggregate it.
D. Ask the modeler to create a calculated category in Transformer and then use it directly.
|
Download Printable PDF. VALID exam to help you PASS. |
 |