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.
Story Table Query Page.
You want to create a page in a canvas report that includes a custom image, a user editable title centered underneath the image, and the current date in the top-right corner. Which combinations of components can you use to accomplish this?
Note: There are 2 correct answers to this question.
1 custom image component, 2 rich text components 1 custom image component, 1 rich text component 1 custom image component, 1 rich text component, 1 simple text component 1 custom image component, 1 simple text component.
Where can you obtain the latest versions of the standard report templates provided by SAP Success Factors?
SAP Help Portal SAP PartnerEdge SuccessFactors HCM Cloud Operations Portal SAP Support Portal.
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?
Business Intelligence Reporting Tool (BIRT) YouCalc designer LMS Report Designer PDFSam.
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.
Configure a table restriction of the Compensation table. Duplicate the Compensation table. Configure a table restriction of the Global Job Information table. Change the table join to the Compensation table to an inner join.
When you use a column of type text as a measure in a pivot query, which of the following pivot functions are available?
Note: There are 2 correct answers to this question.
Max Distinct Count
Sum Concatenate.
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.
Dynamic Groups Manage Report Center Role Based permission Groups Role Maintenance.
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?
Use the Restore Deleted Report tool to restore the report. Use the Recycle Bin to restore the Report. Create a new report and add orphaned pages. Share the report. Contact Successfactors support to request the report be restored.
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.
Show All As of Date with a dynamic date value of Today Date Range (On Start Date) with a date range from Today to Today Current Date.
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?
Remove the related table and add it using the Show Related Tables command form the Action Menu. Change the join type to Left Outer Join. Remove the related table and select and drag it from the Available Data section. Change the join type to Inner Join.
Why would you export report definitions?
Note: There are 2 correct answers to this question.
To distribute reports to report consumers To move reports between company instances To support report version control To schedule reports for offline execution.
You want to create a report that shows onerow per employee, that includes the total number of previous employers for each employee. Which tool must you use?
Calculated Columns Runtime Filters Aggregated Calculated Columns Date Options.
A table report is shared with a user. That user CANNOT see the table report in the Report Center list.
Which role-based permission has NOT been set correctly for this user?
Access to Insights Create Report access to the domain Run Report access to the domain Ability to manage Tiles and Dashboards.
A report shows one row for each language an employee speaks. The employee information "Firstname" 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?
Show Total Row Column Style Settings Sum Function Group Columns.
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.
Switch between edit and view mode. Add/delete widgets. Adjust filters within controls. Freeze table rows/columns. Show/hide labels.
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?
Employees of the Sales department Employees of the Sales departments and all employees of Atlanta Employees of the Sales department of Atlanta Employees of Atlanta.
When using Report Center, what permissions are required to create a canvas report on Employee Profile data using the Detailed Reporting tool?
Note: There are 3 correct answers to this question.
Report Center Report - Canvas Designer Create Reports: Employee Profile Report - Canvas Designer Admin Run Report: Employee Profile.
You want to create a report thatreturns only employees who were born in 1961. You also want to enable the person who runs the report to specify a different birth year.
How can you achieve this?
Note: There are 2 correct answers to this question.
1. Select Date Options from the Toolbar.
2. Set Date Type to Date Range (On Start Date).
3. Set From date to 1/1/1961 and To date to 12/31/1961.
4. Set Use Custom Columns.
5. Select Date of Birth from Start Date Column.
6. Set Selectable At Runtime. 1. Select Date Options from the Toolbar.
2. Set Date Type to As of Date.
3. Set As of Date to 1/1/1961.
4. Set Use Custom Columns.
5. Select Date of Birth from Start Date Column.
6. Select Date of Birth from End Date Column.
7. Set Selectable At Runtime. 1. Select Date Options from the Toolbar.
2. Set Date Type to Show All.
3. Select Manage Run Time Filters from the Toolbar.
4. Expand Personal Information table.
5. Select Date of Birth column.
6. Select OK. 1. Select Manage Query Filters.
2. Expand Personal Information table and select Dateof Birth.
3. Select Greater than or equal to from the operator list.
4. Set Custom filter date to 1/1/1961.
5. Select OK and then select Add.
6. Expand Personal Information table and select Date of Birth.
7. Select less than or equal to from the operator list.
8. Set Custom filter date to 12/31/1961.
9. Select OK.
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?
Configure a filter to remove the duplicate column. Remove the column that wouldgenerate multiple entries per metric. Change the metric calculation from Count to Count distinct. Remove the category assignment field.
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 tablefrom 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?
Only related or joined tables appear as available. The table does NOT have a Report Object Configuration Entity record. You do NOT have the data access permission to the schema. You do NOT have RBP permission to the fields of the table.
How do you give an analyst permission to build tiles?
Add the analyst to the role-based permission group Dashboard Administrators. Assign the analyst asa dashboard administrator in Provisioning. Assign the role-based permission in the Manage Dashboards/Reports RBP Category. Assign the role-based permission in the Analytics RBP Category.
What setting in Provisioning enables Live data source?
LM5 Client API EC Client Workforce Analytics Client Platform Client.
Which fields can you format using Column Formatting on the Edit menu?
Note: There are 2 correct answers to thisquestion.
Currency fields Date fields Picklist fields Number fields.
What are the steps to create and assign a date filter to a tile?
1. Enable the date filter in the tile.
2. Access Date Options.
3. Configure date type to Date Range.
4. Configure the date from/date to.
5. Configure end user free selection of date range. 1. Enable the date filter in the tile.
2. Create a new date range.
3. Configure the Name, label and date from/date to.
4. Configure end user free selection of date range. 1. Access Date Options.
2. Configure the date type to Date Range.
3. Configure the date from/date to.
4. Enable the date filter in the tile.e
5. Configure enduser free selection of date range 1. Create a new date range.
2. Configure the Name, label and date from/date to.
3. Enable the date filter in the tile.
4. Configure end user free selection of date range.
Whatis included in the saved state of a bookmark for a Story report?
Note: There are 3 correct answers to this question.
Prompts Comments Input Controls Data Filters.
What is the first step to make Ad Hoc reporting available for a customer?
Enable Ad Hoc report builder and domain schemas in Provisioning. Enable Table reports by assigning Role Based Permissions. Enable Table reports in Admin Center-> Upgrade Center. Enable Table reports in Admin Center-> Reporting & Analytics.
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.
Report Center-> Edit the Report Report Distributor -> Validate Admin Center -> Manage Report Center Admin Center -> Report - Canvas Validation.
You want to create a query that includes information about an employee's current job, as well as information such as name and date of birth. How do you do this?
Note:There are 2 correct answers to this question.
1. Select Employment from the Category drop down.
2. Expand the Global Job Information table.
3. Select the applicable job-related fields from Global Job Information.
4. Navigate to and expand the Person Category from within the Employment category.
5. Expand the Personal Information table.
6. Select the applicable personal fields from the Personal Information table. 1. Select Person from the Category drop down.
2. Expand the Personal Information table.
3. Select the applicable personal fields from the Personal Information table.
4. Navigate to and expand the Employment Category from within Person category.
5. Expand the Global Job Information table.
6. Select the applicable job-related fields from the Global Job Information table. 1. Select Employment from the Category drop down.
2. Expand the Global Job Information table.
3. Select the applicable job-related fields from Global Job Information.
4. Navigate to and expand the User Category from within the Employment category.
5. Expand the Employee Information table.
6. Select the applicable personal fields from the Employee Information table. 1. Select User from the Category drop down.
2. Expand the Employee Information table.
3. Select the applicablepersonal fields from the Employee Information table.
4. Navigate to the Employment category from within User and expand.
5. Expand the Global Job Information table.
6. Select the applicable job-related fields from the Global Job Information table.
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.
Set a run-time filter on User Sys ID. Set the People Scope Team Manager to Logged in User and set Team Reporting Type to other filters. Enable User Prompted People Scope.
When you share a tile, how can the user view that tile?
Note: There are 3 correct answers to this question.
Dashboard Homepage Mobile Canvas Report Custom table report.
What is the purpose of the Include Starting From User setting in People Scope?
To include users the report is shared with To include a range of users To include the results for the user the report is running for To include the user column as the first column.
You are configuring a story report. You add the image widget to the top-left corner of the canvas. You then upload the SuccessFactors logo in the Builder and select the logo image so it displays on the canvas. When you preview the report in View Mode, the logo appears centered on the canvas.
What action do you take so the Logo appears in the top-left corner when viewing the report in view mode?
In Builder for the image, set the image to Dynamic. In Styling for the page, set the Page Size to Fixed. In Designer Mode, add another widget under the image. In Styling for the image, set the Image Properties to Pan.
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 belisted in the Available Data section of Query Designer?
Create a Report Schema Configuration Entity Record. Update the Report Object Configuration Entity record for the object and set it as a root report object. Create a custom schema join usingthe Report Schema Join Manager tool. Update the Report Object Configuration Entity record for the object and associate the object with a schema.
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?
User B has NOT been assigned ownership of the fourth tile. User B does NOT have run permission to the domain the fourth tile is based upon The fourth tile has NOT been shared. User B has NOT been assigned permission to see the fourth tile.
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?
Change the Job Relationship join to a left join. Change the Job Relationship to include a table restriction. Change the Job Relationship join to a right join. Change the Job Relationship join to an inner join.
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?
You are using a query with a static date filter You are NOT using a template. You are using a wrong People Scope. You are using the percent of total option.
The data source used by the two tables only displays current (active) employees. How would you configure a filter on the table End of Previous Year Headcount by Location to display data accurately?
Note: There are 2 correct answers to this question.
Set a filter on Hire Date (Range) Set the Range type to Offset Set the Range type to Standard Set a filter on Hire Date (Member).
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.
Report Permission -> Create Report - Story Report Permission -> Create Report Career Development Planning -> Career Development Plan (CDP) Access Permission Career Development Planning -> Data Access: Report - Story.
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.
Data is NOT joined in the query. Report results are shown on separate tabs in the output. Data is joined in the query. Report results are shown on a single tab in the output.
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 answersto this question. The Job information table time filter is set to: As of Date > Dynamic Date: Today. The compensation table time filter is set to: Same Filter as First Table. The Query Advanced Filter is set to: Job Information effective start date equal to Dynamic Date: Today. The compensation table time filter is set to: As of Date > Dynamic Date: Today.
When you create a table report, in which step can you include inactive users?
General People Columns Filters.
Which are valid destinations of a scheduled Report Distributor bundle?
Note: There are 3 correct answers to this question.
Home Page SFTP Notification Run Offline E-Mail.
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? Configure it for Linked Analysis. Enable Cascading Effects. Convert it to a Story Filter. Create the corresponding filter on each chart.
You are trying to create a conditionalexpression 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? : , " #.
When you create a table report with filter groups, what is the logical relationship between filter groups?
AND OR NOT.
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.
Reports Permission: Create Report Report creation User Prompted Filters step Reports Permission: Run Report Report creation People step.
What can you hide from query results using the Edit menu of Detailed Reporting?
Duplicate rows Duplicate timestamps Duplicate calculated columns Duplicate columns.
You want to return the quarter to date event records to count terminations. Which options would you set in the time filter?
Note: There are 3 correct answers to this question.
Range Parameters: Period to Date Range Type: dynamic Range Type: fixed Records Returned: Include only records that begin in your defined date range Range period: Actual start/end date of the current quarter.
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?
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 Personal Information is joined to both the Dependents table and the Address table with an inner join. 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. Personal Information is joined to both the Dependents table and the Address table with a left join.
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.
Report Distributor Report Center FTP Distribution Report Transfer.
How can you give users permissions to see a tile?
1. Go to Admin Center.
2. Go to User Privileges -> Report Permissions.
3. Click Permissions.
4. Select Role.
5. Select ManagePermission Roles.
6. Enable Analytics Tiles and Dashboards. 1. Go to Admin Center.
2. Select User Privileges.
3. Select Role.
4. Enable Analytics Tiles and Dashboards 1. Go to Admin Center.
2. Select Manage Permission Roles.
3. Select Role.
4. Click Permission.
5. Go to User Privileges -> Reports Permissions.
6. Enable Analytics Tiles and Dashboards. 1. Go to Admin Center.
2. Select Role.
3. Click Permission.
4. Go to User Privileges -> Reports Permissions.
5. Enable Analytics Tiles andDashboards.
When you format a list report component, which actions can you perform?
Note: There are 3 correct answers to this question.
Change column types. Change column headers. Change the order of columns. Adjust column widths. Save formats to a template.
You create a report page and want to change the grid column width and grid row height. Where can you do this?
Edit designer properties Edit Query Validate page Edit page properties.
You want to build a query for a cross-domain report. What does the system do with fields that are NOT available for this report?
Unavailable fields are marked grey. Unavailable fields are moved to the bottom of the list. Unavailable fields are marked red. Unavailable fields are hidden.
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?
Edit user B's WFA Role configuration. Assign User B the permission Access All Reports. Update the reports' sharing to include user B. Edit authorship of the report.
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.
Row: Count Table Structure: Aggregated List Column: Count Table Structure: Cross-tab Location: Count.
When constructing an expression for a calculated column, which syntax should you use to enter a date?
#MMM-DD-YYYY# #MM-DD-YYYY# #DD-MM-YYYY# #YYYY-MM-DD#.
What provisioning setting must you enable to allow customers to upload a custom BIRT template to a Table Report?
Enable Visual Publisher. Enable Bl Publisher to BIRT Template Converter. Additional Adhoc Sub domain Schemas Configuration. Allow Bl Publisher template upload.
When a user builds a query, what is the default People Scope of the query?
All Reports of the logged-in user All employees in the department of the logged-in user Direct Reports of the logged-in user The matrix reports of the logged-in user.
You support report consumers. A report consumer asks if it is possible to save the selected items when viewing the detail of a chart ina story report (see screenshot). How do you tell the report consumer to save the state?
Note: There are 2 correct answers to this question. View the chart in explorer mode, view the action menu, and choose Export.
View the chart in explorer mode and choose + New View to create an explorer view. Select the chart on the canvas, view the bookmark menu and choose Bookmark Current State. Select the chart on the canvas, view the action menu, and choose Export.
You want to create a tile-based dashboard and make it available to users. After you created and named the dashboard, which steps are required?
1. Create tile(s).
2. Select dataset.
3. Share dashboard. 1. Select tile(s).
2. Save dashboard.
3. Share dashboard 1. Select tile(s).
2. Select dataset.
3. Save dashboard. 1. Create tiles(s).
2. Select filters.
3. Save dashboard.
You want to create a pie chart of your company's headcount by country. For each slice you want to display the proportion by country and the country name. Which formatting options must you select?
Note: There are 2 correct answers to this question.
Use Smart Labels Percent of Total Chart type: Area Rolling Averaqe.
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.
Microsoft Word Adobe PDF Microsoft Powerpoint Microsoft Excel XML format.
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?
Inner Left Outer.
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.
Advanced cell level formulas FTP scheduling Simple data extraction Printable chart with custom formatting requirements.
What is a prerequisite for using the SuccessFactors standard report templates?
The customer must have enabled the templates in Provisioning. The templates must have been downloaded from the Success Store. The templates must have been loaded within Report Center. The customer must have licensed SuccessFactors Employee Central.
Which tool can you use to create tiles offline?
Detailed Reporting Advance Reporting YouCalc Designer Query Workspace.
User A schedules a report in Report Center Scheduler. What can user A achieve by enabling the Job Completion notification option for a scheduled job in the Report Center Scheduler?
An e-mail is sent to the recipient of the report that the report distribution process is complete with the report. A notification appears for the recipient of the report on the home page after the report distribution process is complete. A notification appears for user A on the home page after the report distribution process is complete. An e-mail is sent to user A after the report distribution process is complete.
If you want to create a single filter that utilizes criteria from multiple tables in the same query, which filter doyou need to use?
Query Advanced filter Table Advanced filter Query Scope filter Table Simple filter.
How do you configure the Builder to display the chart in the screenshot in a story report?
Note: There are 3 correct answers to this question.
Set Dimensions to Pay Grade Set Color to Pay Grade Set Dimensions to Gender Set Measures to EOP Headcount Set Color to Gender.
Which actions can you perform in a Simple Text component?
Note: There are 3 correct answers to this question.
Select the font, font size, and font style options for the text. Select an image to display inline within text.
Select the background color, numeric list options, and indentation for the text. Add a link to an existing canvas report. Upload an image to display before or after the text.
You are creating a calculated column to calculate an employee's organizational tenure. Why does the formula in the screenshotresult in an error?
The result of the formula is negative. An incorrect data type has been selected. An incorrect dynamic date variable has been used. . An "if then else" statement needs to be included.
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?
Cell level permission Run report permission Row level permission Field level permission.
A user wants to build a pivot chart based on a list report that has a run-time filter. What must the user do?
Create a filter group within the run-time filter before building the report. Create the pivot chart after adding the run-time filter Create the run-time filterbefore building the report. Create the pivot chart before adding the run-time filter.
An administrator creates a new MDF object forstoring 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?
Use WFA on HANA Data Factory to rebuild the cube. Use Purge Advanced Reporting Metadata Cache Tool. Use Refresh Analytics Permissions Tool. Request a Metadata Refresh from SuccessFactors Support.
Why is it important to consider the People step of the report definition when you share a table report with another user?
The user may NOT have access to the fields in the report. The user may NOT have access to run reports. The user may NOT have the same line of sight. The user may NOT have access to the relevant report domain.
Which of the following would make it possible for a filter to update multiple charts using linked analysis?
Note: There are 2 correct answers to this question.
The data sources for the charts should contain linked dimensions. The charts should have the same data source. The charts should use the same measures. The chart should use the same aggregation.
When you share a canvas report, from where can the user access that report?
Note: There are 2 correct answers to this question.
Metrics Panel Home Page Reporting Menu Report Center.
What functionality can be used in a calculated column? Note: There are 2 correct answers to this question.
If/Then/Else statement Data type conversion Concatenation Average.
In a live data query, what are user-prompted filter types?
Note: There are 2 correct answers to this question.
Runtime People Scope Filter Groups Dynamic.
What must you do to ensure that a report consumer can update an employment record from a canvas report?
Enable Make User Editable on the list report component. Include the Username field in a list report component on the report page. Include the User ID field in a list report component on the report page Enable Form Based View on the list report component.
You want to build an operational report that contains a list of recruiting data.
Which of the following SAP SuccessFactors Reporting tools can you use?
Note: There are 3 correct answers to this question. Workforce Analytics Dashboards & Tiles Page Designer Pixel Perfect Talent Cards Table Report Builder.
When you transfer a canvas report, what can you use to upload and validate the entire report?
Note: There are 2 correct answers to this question.
Upload the report using Import Report Definition in Report Center. Validate the report using Page Designer in Report Center. Validate the report using Canvas Validator in Admin Tools. Upload the report using Detailed Reporting in a Canvas Report.
Apart from Image, which other Page Designer components can you use to add an image to a report?
Note: There are 2 correct answers to this question.
Logo Simple Text Chart Rich Text.
Which of the following reporting schemas/domains can be used to define a Data Set?
Note: There are 2 correct answers to this question.
Learning Compensation Eligibility 360 Multi Rater Subject Succession.
In regard to Employee Central data, what do Advanced Reporting Categories consist of?
Tables, MDF objects, and Foundation objects Blocks, MDF objects, and Foundation objects Blocks, tables, and columns Logically grouped tables and columns.
|
