What is included in a Fact table? Note: There are 2 correct answers to this question.
- A . Only the most recent data change
- B . Employee details
- C . Hierarchy structure
- D . IDs to link to dimension tables
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)
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
What is the correct order of phases in the SAP SuccessFactors Workforce Analytics implementation timeline?
- A . Prepare Explore Realize Deploy
- B . Prepare Explore Deploy Realize
- C . Discover Prepare Realize Deploy
- D . Discover Explore Deploy Realize
What block in SAP SuccessFactors Employee Central contains both the person-ID and the user-ID fields?
- A . Person Information
- B . Employment Information
- C . Biographical Information
- D . Job Information
What information is available on the Load Status screen? Note: There are 2 correct answers to this question.
- A . Load history
- B . Filters (Type, Date, Status)
- C . Client list
- D . Server load status
The SAP SuccessFactors standard calculated column configuration for Annual Salary has which functionalities? Note: There are 2 correct answers to this question.
- A . A consultant can add multiple pay component IDs into the same calculated column to track them.
- B . Destination Currency is specified in the
- C . Currency conversion is auto calculated in the software. No configuration is needed in the Data Factory.
- D . If multiple pay component IDs are specified in the
You are building a Fact table for a customer with SAP SuccessFactors Workforce Analytics on SAP HANA.
What needs to be included in this table? Note: There are 3 correct answers to this question.
- A . Analysis dimension IDs
- B . Base input measures
- C . Result measures
- D . Structural dimension IDs
- E . Derived measures
Which of the following dimensions should NOT be turned on for Measure Hires?
- A . Separation Reasons
- B . Future Leader
- C . Gender
- D . Recruitment Source
Which of the following functions are managed in the WFA on HANA Data Factory tool? Note: There are 3 correct answers to this question.
- A . Enable/disable measures and dimensions for the instance.
- B . Enable/disable role-based permissions for the instance.
- C . Import/export the configuration for a backup or to use in another instance.
- D . Enable/disable incremental processing and frequency and start an out-of-cycle incremental build.
- E . Import/export reports for a backup or to use in another instance.
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 would you validate a result measure ‘retention rate’ if the customer has a concern that the number is NOT accurate? Note: There are 3 correct answers to this question.
Please refer to the formula below: Retention Rate = (SOP Headcount + External Hires – Terminations)/(SOP Headcount + External Hires) *100.
- A . Validate that the External Hires measure produces the correct figure via Drill to Detail.
- B . Validate that the EOP Headcount measure produces the correct figure via Drill to Detail.
- C . Validate that the SOP Headcount measure produces the correct figure via Drill to Detail.
- D . Validate that the Average Headcount measure produces the correct figure via Drill to Detail.
- E . Validate that the Termination measure produces the correct figure via Drill to Detail.
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.
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.
In which hris-element is an employee’s annual salary typically stored in SAP SuccessFactors Employee Central?
- A . employmentInfo
- B . jobInfo
- C . payComponentRecurring
- D . compInfo
What are Derived Input Measures?
- A . Breakdowns of measure values across administrative and geographic structures
- B . Calculations of Base Input Measures and Derived Input Measures combined in formulas
- C . Input of Derived or Result Measures that are NOT displayed in the Measures tab of the Workforce Analytics portal
- D . Base Input Measures filtered by Dimensions
What is the purpose of the Specification document?
- A . It provides a list of discrepancies between the customer’s expected results and SAP results.
- B . It provides an overview of the implementation process.
- C . It contains customer responses to questions related to the implementation process.
- D . It contains all business logic and source data locations for the implementation.
During an SAP SuccessFactors Workforce Analytics on SAP HANA configuration, when can you select the Termination event list?
- A . When creating Hires, Terminations, or Movements conditions
- B . When adding a Termination measure
- C . When configuring Lookups for Event and/or Event Reasons
- D . When configuring Separation Reason Dimensions
A customer wants to implement a Grade/Band dimension using the external code from the Fo Pay Grade T table. The source for all employee grade data is from the Pay Grade column in the Emp Job Info T table.
Which table and columns do you use as Lookup Table, Lookup Column, and Source Column when configuring the Lookup?
- A . Fo Pay Grade T as Lookup Table. Code as Lookup Column. Emp Job Info T>Pay Grade as Source Column
- B . Emp Job Info T as Lookup Table. Pay Grade as Lookup Column. Fo Pay Grade T>Internal Code as Source Column
- C . Emp Job Info T as Lookup Table. Pay Grade as Lookup Column. Fo Pay Grade T>Code as Source Column
- D . Fo Pay Grade T as Lookup Table. Internal Code as Lookup Column. Emp Job Info T>Pay Grade as Source Column
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
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 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.
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.
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
When would you use a Lookup?
- A . When a dimension is sourced from a combination of multiple columns
- B . When the Hire Date is sourced from a different date column for the system upload event
- C . When exclusion logic is based on an external code value of a foundation object
- D . When a dimension needs a description from the Label table
To which measures does the following calculation apply? Note: There are 3 correct answers to this question.
if((in([%EMP_JOB_INFO_T.EMPLOYMENT_STATUS%], ‘A’,’U’,’P’) OR ISNULL([%EMP_JOB_INFO_T.EMPLOYMENT_STATUS%])), [%#CFT#.HEAD_COUNT%], 0).
- A . SOP headcount
- B . Average headcount
- C . EOP headcount
- D . EOP headcount – inactive and other
- E . FTE headcount
What is the purpose of creating Event lists in SAP SuccessFactors Workforce Analytics on SAP HANA?
- A . To apply employee attributes that are sourced from concatenation of multiple source columns
- B . To define the employee movement codes such as Hire, Termination, Promotion, Demotion, and Transfer
- C . To set the value for Recruitment Source and Separation Reason Dimensions
- D . To apply effective dating to an employee movement record
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
A base input measure configured in data factory does NOT produce any result.
Which of the following actions could be helpful to debug the error? Note: There are 3 correct answers to this question.
- A . Create a dummy measure that returns all record from the same fact table.
- B . Create a new query in advanced reporting that returns the values derived for the base input measure.
- C . Add all fields used in measure calculation syntax into Drill to Detail.
- D . Return all records from Drill to Detail and manually check the value against measure syntax.
- E . Temporarily disable Role-Based Permission for the data required to build the base input measure.
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