nerdexam
IBM

C2020-701 · Question #27

C2020-701 Question #27: Real Exam Question with Answer & Explanation

Sign in or unlock C2020-701 to reveal the answer and full explanation for question #27. The question stem and answer options stay visible for context.

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.

Unlock C2020-701 to see the answer

You've previewed enough free C2020-701 questions. Unlock C2020-701 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full C2020-701 Practice