When you create a table report with filter groups, what is the logical relationship between filter
groups? AND OR NOT.
Which actions can you perform in a Simple Text component? Note: There are 3 correct answers to
this question. Select an image to display inline within text. Select the background color, numeric list options, and indentation for the text. Upload an image to display before or after the text. Add a link to an existing canvas report. Select the font, font size, and font style options for the text.
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 Outer Left.
When a user builds a query, what is the default People Scope of the query? All employees in the department of the logged-in user All Reports of the logged-in user The HR reports of the logged-in user Direct Reports of the logged-in user.
What happens when you enable inline translation of a Story as it relates to future edits of the
Story report? Note: There are 2 correct answers to this question. The source language is set to the current locale of the individual who enabled translation. The report can be edited in any language. The source language is chosen from enabled locales on the instance when enabling translation. The report can be edited only in the source language.
In a live data query, what are user-prompted filter types? Note: There are 2 correct answers to this
question. Dynamic Runtime Filter Groups People Scope.
You are constructing a Story. 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 period: Actual start/end date of the current quarter Records Returned: Include only records that begin in your defined date range Range Parameters: Period to Date Range Type: dynamic Range Type: fixed.
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 compensation table time filter is set to: Same Filter as First Table. 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 Query Advanced Filter is set to: Job Information effective start date equal to 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.
View the chart in explorer mode, view the action menu, and choose Export. Select the chart on the canvas, view the action menu, and choose Export. Select the chart on the canvas, view the bookmark menu, and choose Bookmark Current State. View the chart in explorer mode, and choose + New View to create an explorer view.
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? 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. 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.
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. Contact SAP SuccessFactors support to request the report be restored. Create a new report and add orphaned pages. Share the report.
When you share a tile, how can the user view that tile? Note: There are 3 correct answers to this
question.
iOS SF app Canvas Report Custom table report Homepage Dashboard.
A user reports they are unable to successfully create a new Story report in Report Center. The
page is stuck in a blank loading screen. How do you validate the user exists and has the proper
configuration in the SAP Analytics Cloud Solution?
In the WFA administrative area, use the User Maintenance tool to verify the account exists and is
assigned the correct role.
In the SuccessFactors HXM suite, use the Employee Export tool to verify the employee has a
PERSON_GUID assigned.
In the SuccessFactors HXM suite, use the check tool to run the ”Availability of user record for
People Analytics” check.
In the SAC instance, use the Users tool to verify the account exists and is assigned the correct
role.
.
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 Sum Concatenate Distinct Count.
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?
Create tile(s). Select dataset. Share dashboard. Create tiles(s). Select filters. Save dashboard. Select tile(s). Save dashboard. Share dashboard. Select tile(s). Select dataset. Save dashboard.
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.
Select Person from the Category drop down. Expand the Personal Information table. Select the
applicable personal fields from the Personal Information table. Navigate to and expand the
Employment Category from within Person category. Expand the Global Job Information table. Select
the applicable job-related fields from the Global Job Information table.
Select Employment from the Category drop down. Expand the Global Job Information table.
Select the applicable job-related fields from Global Job Information. Navigate to and expand the
User Category from within the Employment category. Expand the Employee Information table.
Select the applicable personal fields from the Employee Information table.
Select User from the Category drop down. Expand the Employee Information table. Select the
applicable personal fields from the Employee Information table. Navigate to the Employment
category from within User and expand. Expand the Global Job Information table. Select the
applicable job-related fields from the Global Job Information table.
Select Employment from the Category drop down. Expand the Global Job Information table.
Select the applicable job-related fields from Global Job Information. Navigate to and expand the
Person Category from within the Employment category. Expand the Personal Information table.
Select the applicable personal fields from the Personal Information table.
.
You need to create a chart of type Indicator: Numeric Point that displays the following output:
count of employees with the gender male divided by the count of employee with the gender
female.
The chart can then be filtered for different departments. What calculation is required to create the
metric?
In Query Builder, use a calculated column. In Chart Builder, use a calculation of type: Restricted Measure. In Chart Builder, use a calculation of type: Calculated Measure. In Chart Builder, use a calculation of type: Aggregation.
You create a report page and want to change the grid column width and grid row height of the
Page Designer. Where can you do this?
Validate page Edit page properties Edit Query Edit designer properties.
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?
Convert it to a Story Filter. Configure it for Linked Analysis. Create the corresponding filter on each chart. Enable Cascading Effects.
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.
What is included in the saved state of a bookmark for a Story report? Note: There are 3 correct
answers to this question.
Input controls Comments Filters Prompts Data.
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?
Update the reports' sharing to include user B. Edit user B's WFA Role configuration. Assign User B the Access All Reports permission. Edit authorship of the report.
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?
PDFSam Business Intelligence Reporting Tool (BIRT) YouCalc designer LMS Report Designer.
In Detailed Reporting, 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 gray. Unavailable fields are hidden. Unavailable fields are marked red. Unavailable fields are moved to the bottom of the list.
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 Global Job Information table. Configure a table restriction of the Compensation table. Change the table join to the Compensation table to an inner join. Duplicate the Compensation table.
When constructing an expression for a calculated column in Query Designer, which syntax should
you use to enter a date?
#MMM-DD-YYYY# #MM-DD-YYYY# #YYYY-MM-DD# #DD-MM-YYYY#.
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.
Simple data extraction Printable chart with custom formatting requirements SFTP scheduling Advanced cell level formulas.
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 the Range type to Offset. Set a filter on Hire Date (Range). Set a filter on Hire Date (Member). Set the Range type to Standard.
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 Transfer Report Center SFTP Configuration Report Distributor.
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.
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. Enable User Prompted People Scope. Set the People Scope Team Manager to Logged in User and set Team Reporting Type to other
filters.
.
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.
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.
Add/delete widgets. Adjust filters within controls. Switch between edit and view mode. Freeze table rows/columns. Show/hide labels.
When you share a canvas report, from where can the user access that report? Note: There are 2
correct answers to this question.
Home Page Reporting Menu Report Center Metrics Panel.
You want to create a report that shows one row per employee, that includes the total number of
previous employers for each employee. Which tool must you use?
Calculated Columns Aggregated Calculated Columns Runtime Filters Date Options.
What are the requirements for a custom block in People Profile to be reportable in a Story? Note:
There are 2 correct answers to this question.
The MDF object must have an externalCode of datatype Generic Object. The MDF object must have an externalCode of datatype User The MDF object must NOT be linked to another schema. The MDF object must be linked to a schema as a root object.
In Query Designer, you are trying to create a conditional expression to relabel a field. You create
the following expression: IF([User#Basic User Information#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?
: " # ,.
You have a field in Job Information that stores the assignment of an employee to a Generic Object
record for a Company Car. Company Car records include an Assignment Date of the Car. You want
to create a query that includes the Employee Information, and also include the Assignment Date of
the Car. You add the Job Information Table to Query Designer. What steps do you take to
accomplish the query? Note: There are 2 correct answers to this question.
In Job information table, select the Assignment Date field. In Job Information table, expand the Company Car Field. In the Company Car table, select the Assignment Date Field. In Related tables, add the Company Car table to the Query.
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 Color to Pay Grade. Set Measures to EOP Headcount. Set Dimensions to Pay Grade. Set Color to Gender. Set Dimensions to Gender.
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, 1 simple text component 1 custom image component, 1 rich text component 1 custom image component, 1 rich text component, 1 simple text component 1 custom image component, 2 rich text components.
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.
Report results are shown on separate tabs in the output. Data is NOT joined in the query. Report results are shown on a single tab in the output. Data is joined in the query.
In a Story, 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 charts should use the same measures. The chart should use the same aggregation. The data sources for the charts should contain linked dimensions. The charts should have the same data source.
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.
Canvas Designer Admin Run Report: Employee Profile Create Reports: Employee Profile Report Center Canvas Designer.
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?
Update the Report Object Configuration Entity record for the object and set it as a root report
object.
Update the Report Object Configuration Entity record for the object and associate the object with
a schema.
Create a custom schema join using the Report Schema Join Manager tool. Create a Report Schema Configuration Entity Record.
Which tool can you use to create tiles offline? Advance Reporting YouCalc Designer Query Workspace Detailed Reporting.
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 the run-time filter before building the report. 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.
Which of the following steps do you take to import an SAP SuccessFactors-provided story report
template? Note: There are 3 correct answers to this question.
Select Import in Report Center. Select Import Data in Import and Export Data tool. Select the template and choose Import. Choose the Content Store tab. Choose the SAP SuccessStore.
In Detailed Reporting, what functionality can be used in a calculated column? Note: There are 2
correct answers to this question.
Concatenation Data type conversion Average If/Then/Else statement.
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 wrong People Scope. You are using a query with a static date filter. You are NOT using a template. You are using the percent of total option.
How do you give an analyst permission to build tiles? Assign the role-based permission in the Analytics RBP Category. Assign the analyst as a dashboard administrator in Provisioning. Add the analyst to the role-based permission group Dashboard Administrators. Assign the role-based permission in the Manage Dashboards/Reports RBP Category.
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 departments and all employees of Atlanta Employees of the Sales department of Atlanta Employees of the Sales department Employees of Atlanta.
What setting in Provisioning enables Live data source? Workforce Analytics Client LMS Client API Platform Client EC Client.
You want to create a report that returns 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.
Select Date Options from the Toolbar. Set Date Type to Show All. Select Manage Run Time Filters
from the Toolbar. Expand Personal Information table. Select Date of Birth column. Select OK.
Select Date Options from the Toolbar. Set Date Type to Date Range (On Start Date). Set From
date to 1/1/1961 and To date to 12/31/1961. Set Use Custom Columns. Select Date of Birth from
Start Date Column. Set Selectable At Runtime.
Select Date Options from the Toolbar. Set Date Type to As of Date. Set As of Date to 1/1/1961.
Set Use Custom Columns. Select Date of Birth from Start Date Column. Select Date of Birth from End
Date Column. Set Selectable At Runtime.
Select Manage Query Filters. Expand Personal Information table and select Date of Birth. Select
Greater than or equal to from the operator list. Set Custom filter date to 1/1/1961. Select OK and
then select Add. Expand Personal Information table and select Date of Birth. Select less than or equal
to from the operator list. Set Custom filter date to 12/31/1961. Select OK.
.
An administrator creates a new MDF object for storing attachments related to an employee's
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 Refresh Analytics Permissions Tool. Use WFA on HANA Data Factory to rebuild the cube. Request a Metadata Refresh from SAP SuccessFactors Support. Use Purge Advanced Reporting Metadata Cache Tool.
What provisioning setting must you enable to allow customers to upload a custom BIRT template
to a Table Report?
Enable Visual Publisher. Additional Adhoc Subdomain Schemas Configuration. Allow BIPublisher template upload. Enable BIPublisher to BIRT Template Converter.
Within a Story, 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 select and drag it from the Available Data section. Change the join type to Left Outer Join. Change the join type to Inner Join. Remove the related table and add it using the Show Related Tables command from the Action
Menu.
.
Why would you export report definitions? Note: There are 2 correct answers to this question. To move reports between company instances To schedule reports for offline execution To distribute reports to report consumers To support report version control.
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 Excel Adobe PDF XML format Microsoft Word Microsoft PowerPoint.
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.
Career Development Planning -> Data Access: Story Report Permission -> Create Report Career Development Planning -> Career Development Plan (CDP) Access Permission Report Permission -> Create Story.
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?
Run Report access to the domain Ability to manage Tiles and Dashboards Access to Insights Create Report access to the domain.
What is a prerequisite for using the SuccessFactors standard canvas report templates? The templates must have been downloaded from the Success Store. The customer must have licensed SuccessFactors Employee Central The customer must have enabled the templates in Provisioning. The templates must have been loaded within Report Center.
You are working with nested labels on your instance in Report Center.
How do you configure the labels as displayed in the screenshot? Note: There are 2 correct answers
to this question.
Edit the Recruiting label in Manage Labels. Set “Nest label in:” to Recruiting. Edit the Talent Management label in Manage Labels. Set “Nest label in:” to Talent Management.
You are creating a Story report on employment and compensation information. You have created
two queries to support the story report. The table and the left chart are using an employment
query as its data source. The right chart uses a compensation query as its data source. Both
queries include the field for the employee Job Title. When you add an input control to the page, it
only filters the table and the left chart.
What action must you take to configure the input control to effect both charts and the table?
Enable Cascading Effects. Convert it to a Story Filter. Set up Linked Dimensions. Update Linked Analysis.
Which are valid destinations of a scheduled Report Distributor bundle? Note: There are 3 correct
answers to this question.
SFTP Notification E-Mail Run Offline Home Page.
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.
Column: Location Row: Count Column: Count Table Structure: Cross-tab Table Structure: Aggregated List.
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 has NOT been assigned permission to see 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.
What are the steps to create and assign a date filter to a tile? Access Date Options. Configure the date type to Date Range. Configure the date from/date to.
Enable the date filter in the tile. Configure end user free selection of date range.
Enable the date filter in the tile. Create a new date range. Configure the Name, label, and date
from/date to. Configure end user free selection of date range.
Create a new date range. Configure the Name, label, and date from/date to. Enable the date filter
in the tile. Configure end user free selection of date range.
Enable the date filter in the tile. Access Date Options. Configure date type to Date Range.
Configure the date from/date to. Configure end user free selection of date range.
.
In Detailed Reporting, which fields can you format using Column Formatting on the Edit menu?
Note: There are 2 correct answers to this question.
Number fields Picklist fields Date fields Currency fields.
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?
Remove the column that would generate multiple entries per metric. Remove the category assignment field. Change the metric calculation from Count to Count (Distinct). Configure a filter to remove the duplicate column.
Where can you obtain the latest versions of the standard canvas report templates provided by SAP
SuccessFactors?
SAP Support Portal SAP PartnerEdge SAP SuccessFactors HCM Cloud Operations Portal SAP Help Portal.
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 in Query Designer?
Table Simple filter Query Advanced filter Query Scope filter Table Advanced filter.
You are configuring a story report. You add the image widget to the top-left corner of the canvas.
You then upload the SAP 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 image, set the Image Properties to Pan. In Designer Mode, add another widget under the image. In Styling for the page, set the Page Size to Fixed.
What is the first step to make table reporting available for a customer? Enable Table reports in Admin Center -> Manage Ad Hoc Reports Enable Table reports by assigning Role Based Permissions. Enable Ad Hoc report builder and domain schemas in Provisioning. Enable Table reports in Admin Center -> Upgrade Center.
You are building a performance report with the Story report type. 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?
You do NOT have RBP permission to the fields of the table. Only related or joined tables appear as available. You do NOT have the data access permission to the schema. The table does NOT have a Report Object Configuration Entity record.
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 in a Story? Note: There are 2 correct answers
to this question.
Query Page Table Story.
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.
.
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.
Report creation People step Reports Permission: Create Report Report creation User Prompted Filters step Reports Permission: Run Report.
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 right join. Change the Job Relationship join to a left join. Change the Job Relationship join to an inner join. Change the Job Relationship to include a table restriction.
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.
When you format a list report component, which actions can you perform? Note: There are 3
correct answers to this question.
Change the order of columns. Adjust column widths. Change column types. Change column headers. Save formats to a template.
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.
Current Date 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.
|
