You create a report page and want to change the grid column width and grid row height. Where can you do this?
When constructing an expression for a calculated column, which syntax should you use to enter a date?
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.
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?
What can you hide from query results using the Edit menu of Detailed Reporting?
As a report owner, you want to share a table report with a user.
What must you configure to ensure the user can access data?
Note: There are 2 correct answers to this question.
You support report consumers. A report consumer asks if it is possible to save the selected items when viewing the detail of a chart in a story report (see screenshot).
How do you tell the report consumer to save the state?
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?
You want to create a query that shows only the current Job Information data for each employee.
On the Job Information table, which date type configurations can you use?
Note: There are 2 correct answers to this question.
You create a query using the Basic User Information table. After you add the Proxy Information table, you notice that some of the basic information records are NO longer displayed in the preview.
How do you adjust the query to return the missing records in the preview?
You are creating a query for a historical compensation story report in Query Designer. You have added the Job Information table to the query, configured a scope filter, and previewed the result to verify you are returning the appropriate employees.
You add the related table Compensation to the query.
When you preview the query, you only get the current compensation information for the employees.
Why do you only receive the current records?
Note: There are 2 correct answers to this question.
You want to join two tables, A and B, and you want to include all rows from Table A, and only matching rows from Table B. Which join type must you use?
In addition to any chart filter you may have applied to your chart, which other filters may be affecting the chart filter, due to the Cascading effect?
Note: There are 2 correct answers to this question.
Which actions can you permit the report consumer to perform by your configuration of Interactive widgets?
Note: There are 3 correct answers to this question.
When you share a canvas report, from where can the user access that report?
Note: There are 2 correct answers to this question.
Why is it important to consider the People step of the report definition when you share a table report with another user?
You are using a Multi Dataset table report without Business Intelligence Reporting Tools (BIRT).
What are characteristics of the report output?
Note: There are 2 correct answers to this question.
You have created a custom MDF object to track company car information. You need to be able to create story reports on the data of the custom MDF object.
What must you do to enable a custom MDF object to be listed in the Available Data section of Query Designer?
The drill-down list of a tile contains more entries than the values displayed in a chart (see attached image).
How do you make the outputs match?