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.)
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.
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 a single tab in the output. Data is joined in the query. Report results are shown on separate tabs in the output.
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.
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? Query Advanced filter Table Advanced filter Query Scope filter Table Simple filter.
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#.
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.
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.
You are creating a calculated column to calculate an employee's organizational tenure.
Why does the formula in the screenshot result 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.
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?
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.
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 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 red. Unavailable fields are marked gray. Unavailable fields are hidden. Unavailable fields are moved to the bottom of the list.
When you create a table report, in which step can you include inactive users? Columns People General Filters.
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 relevant report domain. 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 thefields in the report.
Where can you obtain the latest versions of the standard report templates provided by SAP
Success Factors?
SuccessFactors HCM Cloud Operations Portal SAP Support Portal SAP PartnerEdge SAP Help Portal.
Which actions can you perform in a Simple Text component?
Note: There are 3 correct answers to this question.
Add a link to an existing canvas report. Upload an image to display before or after the text. Select an image to display inline within text. Select the background color, numeric list options, and indentation for the text. Select the font, font size, and font style options for the text.
A manager changed jobs and subsequently lostaccess 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.
Which are valid destinations of a scheduled Report Distributor bundle? Note: There are 3 correct
answers to this question.
Home Page FTP Notification Run Offline E-Mail.
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.
What setting in Provisioning enables Live data source? LM5 Client API EC Client Workforce Analytics Client Platform Client.
When you share a canvas report, from where can the user access that report? Note: There are 2 correct Metrics Panel Home Page Reporting Menu Report Center.
What can you hide from query results using the Edit menu of Detailed Reporting? Duplicate rows Duplicate timestamps Duplicate calculated columns Duplicate columns.
In a canvas report, to which of the following can you export multi page reports in a single transaction? (3 correct) Microsoft Word Adobe PDF Microsoft Powerpoint Microsoft Excel XML format.
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 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 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 from 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.
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? (2 correct)
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 applicable personal fields from 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
.
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.
When you format a list report component, which actions can you perform? (3 correct) Change column types Change column headers Change the order of columns Adjust column widths Save formats to a template.
User A schedules a report in Report Center Scheduler. What can user A achieve by enabling the Job Completition notification option for a scheduled job in the Report Center Scheduler? A notification appears for user A on the home page after the report distribution process is complete A notification appears for the recipient of the report on the home page after the report distribution process is complete An e-mail is sent to the recipient of the report that the report distribution process is complete with the report An e-mail is sent to user A after the report distribution process is complete.
What is the first step to make Ad hoc reporting available for a customer? Enable Table reports in Admin Center -> Reporting & Analytics Enable reports in Admin Center -> Upgrade Center Enable Ad Hoc report builder and domain schemas in Provisioning Enable Table reports by assigning Role Based Permissions.
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 noticed 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.
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? Contact Successfactors support to request the report be restored. Create a new report and add orphaned pages. Share the report. Use the Restore Deleted Report tool to restore the report. Use the Recycle Bin to restore the Report.
Which fields can you format using Column Formatting on the Edit menu? (2 correct) Picklist fields Currency fields Number fields Date fields.
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? (3 correct) Workforce Analytics Pixel Perfect Talent Cards Table Report Builder Dashboards & Tiles Page Designer.
Which permissions should you assign to allow a user to add a new story that will include Career Development Planning data? (2 correct) Report Permission -> Create Report – Story Career Development Planning -> Career Development Plan (CDP) Access Permission Report Permission -> Create Report Career Development Planning -> Data Access: Report - Story.
What permission type applied to table reports is defined by a combination of the user’sView permissions and Target Population in role-based permissions? Run report permission Field level permission Row level permission Cell level permission.
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? (2 correct) Table Query Story Page.
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? The fourth tile has NOT been shared. User B has NOT been assigned permission to see the fourth tile 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.
In regard to Employee Central data, what do Advanced Reporting Categories consist of? Blocks, MDF objects and Foundation objects Blocks, tables and columns Logically grouped tables and columns Tables, MDF objects and Foundation objects.
What features are available only when you use Business Intelligence and Reporting Tools (BIRT) with Table Reports? (2 correct) Printable chart with custom formatting requirements Advanced cell level formulas Simple data extraction FTP scheduling.
Which of the following reporting schemas/domains can be used to define a Data Set? (2 correct) Learning 360 Multi Rater Subject Compensation Eligibility Succession.
Which of the following would make it possible for a filter to update multiple charts using linked analysis? (2 correct) The data sources for the charts should contain linked dimensions. The charts should have the same data source The chart should use the same aggregation The charts should use the same measures.
You create a report page and want to change the grid column width and grid row height. Where can you do this? Edit Query Edit designer properties Validate page Edit page properties.
How can you give users permissions to see a tile? 1. Go to the Admin Center
2. Select Role
3. Click Permission
4. Go to User Privileges -> Report Permissions
5. 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. Go to User Privileges -> Report Permissions
3. Click Permissions
4. Select Role
5. Select Manage Permission Roles
6. Enable Analytics Tiles and Dashboards
.
When a user builds a query, what is the default People Scope of the query? The matrix reports of the logged-in user All Reports of the logged-in user All employees in the department of the logged-in user Direct Reports of the logged-in user.
You want to create a query that shows only the current Job Information data for each employee. On the Job Information table, which data type configurations can you use? (2 correct) As of Date with a dynamic date value of Today Current Date Show All Date Range (On Start Date) with a date range from Today to Today.
What must you do to ensure that a report consumer can update an employment record from a canvas report? Enable Form Based View on the list report component Include the User ID field in a list report component on the report page Include the Username field in a list report component on the report page Enable Make User Editable on the list report component.
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?
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 using the Report Schema Join Manager tool. Update the Report Object Configuration Entity record for the object and associate the object with a schema.
Apart from Image, which other Page Designer components can you use to add an image to a report? (2 correct)
Chart Simple Text Logo Rich Text.
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 pivot chart before adding the run-time filter Create the run-time filter before building the report.
When you transfer a canvas report, what can you use to upload and validate the entire report? (2 correct) Upload the report using Detailed Reporting in a Canvas Report Upload the report using Import Report Definition in Report Center Validate the report using Canvas Validator in Admin Tools Validate the report using Page Designer in Report Center.
Which actions can you permit the report consumer to perform by your configuration of Interactive widgets? (3 correct) Show/hide labels Switch between edit and view mode Adjust filters within controls Freeze table rows/columns Add/delete widgets.
A report shows obe 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 allow you to display the employee information “First name” and “Last name” only once for each employee? Group Columns Show Total Row Sum Function Column Style Settings.
You transferred a report to another instance. Where can you start the validation of this report? (2 correct) Report Center -> Edit the Report Admin Center -> Report – Canvas Validation Report Distributor -> Validate Admin Center -> Manage Report Center.
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? (2 correct) Chart type: Area Percent of Total Use Smart Labels Rolling Average.
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? (2 correct) Set the People Scope Team Manager to Logged in User and set Team Reporting Type to other filters Enable User Prompted People Scope Set a run-time filter on User Sys ID Set the People Scope Team Manager to CEO and set Team Reporting Type to Team View.
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? Assign User B the permission Access All Reports Edit authorship of the report Edit user B’s WFA Role Configuration Update the reports sharing to include user B.
What functionality can be used in a calculated column? (2 correct) Concatenation Average If/The/Else statement Data type conversation.
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 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.
The drill-down list of a tile contains more entries than the values displayed in a Chart. How do you make the outputs match? Configure a filter to remove the duplicate column Remove the column that would generate multiple entries per metric Change the metric calculation from Count to Count distinct Remove the category assignment field.
How do you configure the Builder to display the chart in the screenshot in a story report? (3 correct) Set Dimensions to Pay Grade Set color to Pay Grade Set Dimensions to Gender Set Measures to EOP Headcount Set Color to Gender.
How do you configure the Builder to display the table in the screenshot in a story report? (3 correct)
Headcount by Location:
Table Structure: Cross-tab Column: Count Row: Count Table Structure: Aggregated List.
When you preview the query, you only get the current compensation information for the employees. Why do you only receive the current records? (2 correct) The Job Information table time filter is set to: As of Date -> Dynamic Date: Today The compensation 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.
|
