The human resources department requires a TM1 Web Labor Detail report which shows Total
Salary, Benefits, and Taxes for each employee within a selected department. The user should be
able to select a department and have the rows of the report display just the employees in that
department with the costs across the columns. Employees should be sorted in descending order
based on Total Salary. Unfortunately Salary, Benefits, and Taxes are all stored in different cubes
and the cubes only share the Employee and Department dimensions.
How should you build the Labor Detail report?

A.
Use three slices, one for each of the source cubes and combine using Excel formulas.

B.
Use one slice with zero suppression for Salary and two snapshots for the other cubes.

C.
Use an Active Form.

D.
Use the In-Spreadsheet Browser.

Explanation: