clapgeek logo
Which fields can you format using Column Formatting on the Edit menu?
Note: There are 2 correct answers to this question.
You are creating a Story report on Job Classifications. You have configured the chart, table, and input control on the canvas as displayed in the screenshot.
How do you set the input control?
You are trying to create a conditional expression to relabel a field. You create the following expression:
IF( (UserflBasic User lnformation#Gender] = "M", "Male": "Female ")
You received an error message saying the formula could NOT be computed.
Which symbol in your expression is causing the error?
Why would you export report definitions?
Note: There are 2 correct answers to this question.
An administrator creates a new MDF object for storing attachments related to an employees' dependents. After uploading some test data, the administrator states they are unable to report
on the new data with Advanced Reporting tool in a canvas report. The administrator is working for a client that has already had their system transitioned to Workforce Analytics on SAP HANA.
How can the administrator quickly make the data available for reporting?
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.
What functionality can be used in a calculated column? Note: There are 2 correct answers to this question.
When constructing an expression for a calculated column, which syntax should you use to enter a date?
You are creating a query that lists employee information such as name, address, and dependent information. The query uses Personal Information as the driving table and joins the Dependents and Address tables. You notice many employees are missing from the result set.
What are the reasons?
You transferred a report to another instance.
Where can you start the validation of this report?
Note: There are 2 correct answers to this question.
An executive reviews a canvas report on employee compensation. The executive discovers that NOT all employees are included in the report. You need to adjust the report so that all employees are included by default, but included employees can be adjusted at runtime.
How do you accomplish this task?
Note: There are 2 correct answers to this question.
Which tool can you use to upload a report from the test instance to the production instance?
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?
When you create a table report with filter groups, what is the logical relationship between filter groups?
A manager changed jobs and subsequently lost access to a custom tile-based dashboard.
What functionality would an administrator use to restore access?
Note: There are 2 correct answers to this question.
Which permissions should you assign to allow a user to add a new story that will include Career Development Planning data?
Note: There are 2 correct answers to this question.
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.
Which are valid destinations of a scheduled Report Distributor bundle?
Note: There are 3 correct answers to this question.
TESTED 26 Dec 2024