How do you configure benchmarked dimension nodes in SAP SuccessFactors Workforce Analytics on SAP HANA?
- A . Add a property to a dimension node that flags it as benchmarked.
- B . Change the name of a dimension node to the benchmarked name.
- C . Change the ID of a dimension node to the benchmarked ID.
- D . Map customer nodes to the pre-defined nodes within a dimension.
The following code is used for EOP headcount and SOP headcount:
If((in([%EMP_JOB_INFO_T.EMPLOYMENT_STATUS%], ‘A’,’U’,’P’) OR
ISNULL([%EMP_JOB_INFO_T.EMPLOYMENT_STATUS%])),
[%#CFT#.HEAD_COUNT%], 0) .
Which setting results in each measure produce different results?
- A . Measure override name
- B . Standard measure
- C . Data type
- D . Aggregation type
What is the name of custom objects created with the Metadata Framework?
- A . Generic objects
- B . EC objects
- C . Common objects
- D . Foundation objects
Where can you access the configuration screens for SAP SuccessFactors Workforce Analytics OLAP cube on SAP HANA?
- A . SuccessFactors Admin
- B . WFA on HANA Admin
- C . WFA on HANA Data Factory
- D . Target Setting
How do you validate the value of a local salary that has been converted to the unified target currency for the Annual Salary calculated column? Note: There are 3 correct answers to this question.
- A . Create two calculated columns: one for local salary figure, the other for local currency type, and add them into Drill to Detail.
- B . Create two calculated columns: one for converted target salary figure, the other for target currency type, and add them into Drill to Detail.
- C . Use Drill to Detail to compare source and target salary figures and currencies.
- D . Add all fields used in the Annual Salary calculation syntax into Drill to Detail.
- E . Temporarily disable Role-Based Permissions for the data required to build the base input measure.
A customer has defined the following EVENT codes for their movement logic from EMP_JOB_INFO_T table:
Hire is identified where EVENT External Code = H (Hire) and R(Rehire) Promotion is identified where EVENT External Code = 8 (Promotion) Transfer is identified where EVENT External Code = 6 (Transfer) and 16 (Job Change) Other Movement is identified where EVENT External Code = 23 (Return to Work) Termination is identified where EVENT External Code = 26 (Termination) .
What possible Event Lists can you create to capture all employee movements for this customer? Note: There are 2 correct answers to this question.
- A . Create 3 Event lists: Hire event codes. Termination event codes. Promotion, Transfer, and Other Movement event codes
- B . Create 1 Event list: Hire, Termination, Promotion, Transfer, and Other Movement event codes
- C . Create 5 Event lists: Hire event codes. Termination event codes. Promotion event codes. Transfer event codes. Other Movement event codes
- D . Create 3 Event lists: Hire and Promotion event codes. Transfer event codes. Termination and Other Movement event codes
What could be reasons that codes appear under the ‘Unmapped’ category for a SQL-generated dimension structure? Note: There are 3 correct answers to this question.
- A . The SQL statement returns the external code and employee data uses the external code.
- B . The SQL statement returns the internal code and employee data uses the external code.
- C . The SQL statement returns the external code and employee data uses the internal code.
- D . Leaf node descriptions generated via SQL do NOT match the values returned in the data.
- E . Leaf node IDs generated via SQL do NOT match the values returned in the data.
How do you add columns to the Workforce Fact table?
- A . Select columns in a SQL statement in the Dimensions tab.
- B . Add columns to a Workforce Analytics report.
- C . Add measures in the Measures tab.
- D . Select columns in a table from the Tables and Columns screen.
What do you use a calculated column for in SAP SuccessFactors Workforce Analytics on SAP HANA?
- A . To add a level to the structure of a dimension
- B . To create custom measures
- C . To create aggregations (or pivots) in data
- D . To add additional logic to a base input measure or dimension
How can a technical consultant organize multiple records with the same Effective From Date into one Fact Table record?
- A . Use a calculated column called Effective Sequence.
- B . Use the Effective Sequence Special Use Type on a numeric field.
- C . Use a calculated column to filter unwanted records.
- D . Use the To Date Special Use Type on a date field.
What document is created from the responses to the Data Questionnaire?
- A . Specification document
- B . Discrepancy Report document
- C . Project Summary document
- D . Metrics Pack document
Consider the following scenario: EOP headcount has Age, Disability, EEO Job Category, Employment Level, and Employment Status dimensions turned on. SOP headcount has Age and EEO Job Category dimensions turned on. Average headcount has Gender and Future Leader dimensions turned on. Hires has Age, Disability, EEO Job Category, Employment Level, and Employment Status dimensions turned on. Terminations has Age, Disability, EEO Job Category, Employment Level, and Employment Status dimensions turned on. You are required to perform the following task: Turn on Age, Disability, EEO Job Category, Employment Level, Employment Status and Gender dimensions on for EOP Headcount, SOP Headcount, and Average Headcount .
How would you complete this task? Note: There are 2 correct answers to this question.
- A . Select each required dimension listed above and turn on the missing measures respectively.
- B . Select EOP Headcount and turn on the missing dimensions. Use the Mirror Dimension function to replicate dimensions to both SOP Headcount and Average Headcount.
- C . Select EOP Headcount, SOP Headcount, and Average Headcount at the same time, then turn on the above dimensions in bulk.
- D . Select each measure listed above and turn on the missing dimensions respectively.
Consider the following scenario:
A customer has asked to determine their Hires, Terminations, and Movement Events using the following Event codes:
H C Hire P C Promotion D C Demotion X C Transfer T C Termination. Promotions are only counted if there is an increase in the Salary Band and Demotions are only counted if there is a decrease in the Salary Band .
What is the minimum number of Hire/Movement/Termination conditions that can be created to fulfill these requirements?
- A . 5: An Event List condition for Hires, Internal Movements, and Terminations. An Event List and an Increase in Value for Promotions. An Event List and a Decrease in Value for Demotions
- B . 5: An Event List condition for Hires, Transfers, and Terminations. An Event List and an Increase in Value for Promotions. An Event List and a Decrease in Value for Demotions
- C . 3: An Event List condition for Hires, Promotions, Demotions, Transfers, and Terminations. An Increase in Value for Promotions. A Decrease in Value for Demotions
- D . 7: An Event List condition for each movement type. An Increase in Value for Promotions. A Decrease in Value for Demotions
Some dimension hierarchies in the Dimension Editor tool are greyed out, which prevents you from remapping codes located in the Unmapped node .
Why are the hierarches greyed out?
- A . The code to build the hierarchy is invalid.
- B . The hierarchy is a generated structure based on SQL statement.
- C . The build of the hierarchy did NOT complete.
- D . The checkbox to enable code mapping editing is NOT selected.
What field is the unique identifier for each record of data for a Metadata Framework (MDF) object?
- A . externalCode
- B . Code
- C . externalName
- D . effectiveStartDate
Which of the following SAP SuccessFactors Employee Central tables will be used most often as a Lookup table in SAP SuccessFactors Workforce Analytics on SAP HANA? Note: There are 2 correct answers to this question.
- A . Emp Employment Info table
- B . Fo Event Reason T table
- C . Emp Job Info T table
- D . Fo Pay Component T table
What happens when the Primary Person ID and Secondary Person ID Special Use Type properties are set on a single table?
- A . A mapping is created between the Primary Person within a position and Secondary Person(s) within that position.
- B . A Lookup is created in the Lookup tab to join tables with Primary Person ID to a Secondary Person ID(s).
- C . A mapping is created between an employee’s identifier and the employee’s assignment(s).
- D . A relationship is defined for a parent (primary)/child (secondary) relationship for a supervisor structure.
What is a Condition, in terms of Hires, Movements, and Terminations? Note: There are 2 correct answers to this question.
- A . Used to group Hires, Movements or Terminations
- B . Returns true/false based on an event
- C . A filter to exclude Hires, Movements or Terminations
- D . Used in a calculation to capture Hires, Movements or Terminations
Which rollup types are available when a record is spliced? Note: There are 3 correct answers to this question.
- A . Normal
- B . Prorata
- C . SOP
- D . Average
- E . EOP
How are EEO fields for employees in the United States created in SAP SuccessFactors Employee Central?
- A . Standard fields
- B . Transient fields
- C . Custom fields
- D . Country-specific fields
When you set up SAP SuccessFactors Workforce Analytics on SAP HANA, which field do you use as the primary person identifier when you implement an SAP SuccessFactors Employee Central customer?
- A . Person ID
- B . Users Sys ID
- C . Emplid
- D . Pernr
Which of the following dimensions should NOT be turned on for Measure Hires?
- A . Separation Reasons
- B . Future Leader
- C . Gender
- D . Recruitment Source
To which measures does the following calculation apply?
if((in([%EMP_JOB_INFO_T.EMPLOYMENT_STATUS%], ‘A’,’U’,’P’) OR
ISNULL([%EMP_JOB_INFO_T.EMPLOYMENT_STATUS%])),
[%#CFT#.HEAD_COUNT%], 0). Note: There are 3 correct answers to this question.
- A . SOP headcount
- B . Average headcount
- C . EOP headcount
- D . EOP headcount – inactive and other
- E . FTE headcount
Which of the following are characteristics of the Metadata Framework (MDF)? Note: There are 2 correct answers to this question.
- A . MDF custom objects rely on XML-based configuration.
- B . MDF custom objects are reported on with all SAP SuccessFactors reporting tools.
- C . Customer accounts have a limited number of custom MDF objects.
- D . MDF custom objects are managed with tools in the Admin Center.
How do you configure Effective End Date in SAP SuccessFactors Workforce Analytics on SAP HANA? Note: There are 2 correct answers to this question.
- A . Add the Effective Start Date column and set the Special Use Type option to ToDate.
- B . Add the Effective Start Date column and the staging framework will calculate the end date by default.
- C . Add the Effective End Date column and leave the Special Use Type option to None.
- D . Add the Effective End Date column and set the Special Use Type option to ToDate.
What is used in SAP SuccessFactors Employee Central to determine the most recent record for an employee if there are multiple update records in a day?
- A . Last modified timestamp
- B . Transaction sequence
- C . Created Date
- D . Event
What tool on the WFA on HANA Data Factory home page do you use to configure measure and dimension combinations?
- A . Dimensions
- B . Dimension Editor
- C . Measure/Dimension Arrangement
- D . Measures
Which of the following is configurable and can only be implemented by SAP admin users in the Technical Services team? Note: There are 2 correct answers to this question.
- A . Calculated Columns (Calculated Columns screen)
- B . Custom Measures
- C . Custom Dimensions
- D . Calculated Columns (Tables and Columns screen)
Which of the following tools can you use to restrict user access to metrics and dimensions?
- A . Manage Workforce Analytics
- B . WFA on HANA Data Factory
- C . Manage Permission Roles
- D . Report Center
What are some of the tasks you must perform to complete an SAP SuccessFactors Workforce Analytics on SAP HANA technical implementation? Note: There are 2 correct answers to this question.
- A . Create a custom report.
- B . Update the Data Specification document.
- C . Configure single sign-on.
- D . Configure the Drill-to-Detail display.