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.
|
Download Printable PDF. VALID exam to help you PASS. |
 |