IBM
C2020-701 · Question #27
The human resources department requires a TM1 Web Labor Detail report which shows Total Salary, Benefits, and Taxes for each employee within a selecteddepartment. The user should be able to select a…
The correct answer is C. Use an Active Form. See the full explanation below for the reasoning.
Question
The human resources department requires a TM1 Web Labor Detail report which shows Total Salary, Benefits, and Taxes for each employee within a selecteddepartment. 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. UnfortunatelySalary, 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?
Options
- AUse three slices, one for each of the source cubes and combine using Excel formulas.
- BUse one slice with zero suppression for Salary and two snapshots for the other cubes.
- CUse an Active Form.
- DUse the In-Spreadsheet Browser.
How the community answered
(50 responses)- A4% (2)
- B10% (5)
- C84% (42)
- D2% (1)
Community Discussion
No community discussion yet for this question.