A report consumer claims that a canvas report shared with them is NO longer available in Report Center. Upon your investigation, you find the report has been deleted. You need to reproduce the report as quickly as possible.
What action do you take?

A user wants to build a pivot chart based on a list report that has a run-time filter.
What must the user do?

You want to create a report that shows one row per employee, that includes the total number of previous employers for each employee.
Which tool must you use?

In the Advanced Reporting tool, you want to create a query where the results meet the following criteria
* Only show one row per employee,
* Only show the pay components Base Salary and Bonus,
* Show these pay components as individual columns.
You have joined the Global Job Information table with the Compensation table.What else must you do?

Note: There are 2 correct answers to this question.

In the Advanced Reporting tool, you want to create a query that includes the employee's matrix manager.
When you configure the table join with the Job Relationships table, the Results tab displays multiple rows per employee that also include relationships to HR managers and second managers.
How do you configure the query to return one row per employee that shows the employee's matrix manager when assigned?