How do you configure the Builder to display the table in the screenshot in a story report? Note: There are 3 correct answers to this question. Headcount by Location
- A . Row: Count
- B . Table Structure: Aggregated List
- C . Column: Count
- D . Table Structure: Cross-tab
In a live data query, what are user-prompted filter types? Note: There are 2 correct answers to this question.
- A . Runtime
- B . People Scope
- C . Filter Groups
- D . Dynamic
User A maintains a canvas report of employee contact information. User A leaves the company. Another report designer, user B, is assigned the responsibility to maintain the report, but currently CANNOT modify the report.
How do you allow user B to modify only this report?
- A . Edit user B’s WFA Role configuration.
- B . Assign User B the permission Access All Reports.
- C . Update the reports’ sharing to include user B.
- D . Edit authorship of the report.
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?
- A . Configure it for Linked Analysis.
- B . Enable Cascading Effects.
- C . Convert it to a Story Filter.
- D . Create the corresponding filter on each chart.
While constructing a dashboard, you find that you need to create a tile that requires more complex configuration than what is available with the Online Tile Builder tool.
What tool can you use to create this tile?
- A . Business Intelligence Reporting Tool (BIRT)
- B . YouCalc designer
- C . LMS Report Designer
- D . PDFSam
In a canvas report, to which of the following can you export multipage reports in a single transaction? Note: There are 3 correct answers to this question.
- A . Microsoft Word
- B . Adobe PDF
- C . Microsoft Powerpoint
- D . Microsoft Excel
- E . XML format
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.
- A . Set the People Scope Team Manager to CEO and set Team Reporting Type to Team View.
- B . Set a run-time filter on User Sys ID.
- C . Set the People Scope Team Manager to Logged in User and set Team Reporting Type to other filters.
- D . Enable User Prompted People Scope.
You are using Report Center to share a canvas report. You share the report with a Dynamic Group (see attached image).
Who is the report shared with?
- A . Employees of the Sales department
- B . Employees of the Sales departments and all employees of Atlanta
- C . Employees of the Sales department of Atlanta
- D . Employees of Atlanta
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?
- A . Personal Information is joined to Dependents table with a left join and the Dependents table is joined to the Address table with a left join.
- B . Personal Information is joined to both the Dependents table and the Address table with an inner join.
- C . Personal Information is joined to Address table with a left join and the Address table is joined to the Dependents table with a left join.
- D . Personal Information is joined to both the Dependents table and the Address table with a left join.
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?
- A . Change the Job Relationship join to a left join.
- B . Change the Job Relationship to include a table restriction.
- C . Change the Job Relationship join to a right join.
- D . Change the Job Relationship join to an inner join.
What is the first step to make Ad Hoc reporting available for a customer?
- A . Enable Ad Hoc report builder and domain schemas in Provisioning.
- B . Enable Table reports by assigning Role Based Permissions.
- C . Enable Table reports in Admin Center-> Upgrade Center.
- D . Enable Table reports in Admin Center-> Reporting & Analytics.
When you create a table report with filter groups, what is the logical relationship between filter groups?
- A . OR
- B . AND
- C . NOT
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.
- A . Switch between edit and view mode.
- B . Add/delete widgets.
- C . Adjust filters within controls.
- D . Freeze table rows/columns.
- E . Show/hide labels.
You are building a performance report. In reviewing the Performance Management schema, you notice that the 2019 Performance Review Table is listed in the Available Data section. You begin the query by adding the Basic User Information table from the User schema. You notice that the 2019 Performance Review Table is NO longer listed in the Available Data section.
Why is the 2019 Performance Review table NOT in the list?
- A . Only related or joined tables appear as available.
- B . The table does NOT have a Report Object Configuration Entity record.
- C . You do NOT have the data access permission to the schema.
- D . You do NOT have RBP permission to the fields of the table.
You are using a pivot table in your canvas report but the report does NOT display the most recent data.
What could be the reason?
- A . You are using a query with a static date filter.
- B . You are NOT using a template.
- C . You are using a wrong People Scope.
- D . You are using the percent of total option.
What setting in Provisioning enables Live data source?
- A . LM5 Client API
- B . EC Client
- C . Workforce Analytics Client
- D . Platform Client
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?
- A . Use WFA on HANA Data Factory to rebuild the cube.
- B . Use Purge Advanced Reporting Metadata Cache Tool.
- C . Use Refresh Analytics Permissions Tool.
- D . Request a Metadata Refresh from SuccessFactors Support.
If you want to create a single filter that utilizes criteria from multiple tables in the same query, which filter do you need to use?
- A . Query Advanced filter
- B . Table Advanced filter
- C . Query Scope filter
- D . Table Simple filter
What provisioning setting must you enable to allow customers to upload a custom BIRT template to a Table Report?
- A . Enable Visual Publisher.
- B . Enable Bl Publisher to BIRT Template Converter.
- C . Additional Adhoc Sub domain Schemas Configuration.
- D . Allow Bl Publisher template upload.
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.
- A . The Job information table time filter is set to: As of Date > Dynamic Date: Today.
- B . The compensation table time filter is set to: Same Filter as First Table.
- C . The Query Advanced Filter is set to: Job Information effective start date equal to Dynamic Date: Today.
- D . The compensation table time filter is set to: As of Date > Dynamic Date: Today.
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.
- A . View the chart in explorer mode, view the action menu, and choose Export.
- B . View the chart in explorer mode and choose + New View to create an explorer view.
- C . Select the chart on the canvas, view the bookmark menu and choose Bookmark Current State.
- D . Select the chart on the canvas, view the action menu, and choose Export.
Which are valid destinations of a scheduled Report Distributor bundle? Note: There are 3 correct answers to this question.
- A . Home Page
- B . FTP
- C . Notification
- D . Run Offline
- E . E-Mail
When you format a list report component, which actions can you perform? Note: There are 3 correct answers to this question.
- A . Change column types.
- B . Change column headers.
- C . Change the order of columns.
- D . Adjust column widths.
- E . Save formats to a template.
A report shows one row for each language an employee speaks. The employee information "First name" and "Last name" is repeated for each language on each row.
Which format option allows you to display the employee information "First name" and "Last name" only once for each employee?
- A . Show Total Row
- B . Column Style Settings
- C . Sum Function
- D . Group Columns
What permission type applied to table reports is defined by a combination of the user’s View permissions and Target Population in role-based permissions?
- A . Cell level permission
- B . Run report permission
- C . Row level permission
- D . Field level permission
User A creates a dashboard with four tiles. When User B accesses the dashboard, only three tiles are visible.
Why can User B see only three tiles?
- A . User B has NOT been assigned ownership of the fourth tile.
- B . User B does NOT have run permission to the domain the fourth tile is based upon.
- C . The fourth tile has NOT been shared.
- D . User B has NOT been assigned permission to see the fourth tile.
What features are available only when you use Business Intelligence and Reporting Tools (BIRT) with Table Reports? Note: There are 2 correct answers to this question.
- A . Advanced cell level formulas
- B . FTP scheduling
- C . Simple data extraction
- D . Printable chart with custom formatting requirements
Which tool can you use to create tiles offline?
- A . Detailed Reporting
- B . Advance Reporting
- C . YouCalc Designer
- D . Query Workspace
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.
- A . Show All
- B . As of Date with a dynamic date value of Today
- C . Date Range (On Start Date) with a date range from Today to Today
- D . Current Date
You are creating a calculated column to calculate an employee’s organizational tenure.
Why does the formula in the screenshot result in an error?
- A . The result of the formula is negative.
- B . An incorrect data type has been selected.
- C . An incorrect dynamic date variable has been used.
- D . An "if then else" statement needs to be included.