Symptom
How To Retrieve Dependent Related Person ID?
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- SAP SuccessFactors HXM Suite
- Report Canvas
- Employee Central - Dependents Management
Resolution
Create a New report
- Go to Report Center
- Click on Report Canvas -Then Select
- Give your report a name
- Mouse over table
- Click table and Drag down
- Click on: Edit Query
- Select Advance Reporting
- New
- OK
Step 1: Select Parent or Root table
- Person
- Select Person Child Table Personal Information
- Select and drag First Name - Last Name - UserID or SuccessFactors ID
Step 2: Select Child Table Dependents
Dependents
Select and drag Related Person Id - Relationship (Picklist Label)
Step 3: Select Dependents Child Table Dependent Personal Info
- Dependent Personal Info
- Select and drag Dependent First Name - Dependent Last Name
Step 3:
- Save Report
- Click Objects and View Report overview
See
Filter EC user
- Click on:Manage Filter Query
- Select User ID
- Save Report
View Report Result
- Click Results
- Related Person ID displayed for EC User Dependent
Important: Save your canvas report: 2543169 - How to Save the Query in Report Center for future use
FAQ - Additional Information
Q) Where can I get information on this from the Guide?
A) Guide: Implementing Dependents
See Also
- 2092840 - Importing Dependent Information into Employee Central
- 2368375 - How to Set Up and Use Date Options in Advanced Reporting,
- 2470903 - How to use "Effective From" and "Effective To" filters to obtain historical/future records - Integration Center
- 2186440 - Employee Central: Error Importing new Dependents via Compound Dependent import using Incremental mode
- 2274679 - How to Delete/Delimit Dependents Data via Import
- 2323484 - Error: Unable to import Consolidated Dependents data
- 2280959 - Unable to generate an Ad Hoc Report for Dependents data
- 2543169 - How to Save the Query in Report Center for future use
- 2776882 - EC Advanced Reporting Metadata Sync / Reload (View Based Metadata)
- 2186440 - Error: Importing new Dependents via Compound Dependent import using Incremental mode
- 2584658 - How to Check if a User is an EC User using the Integration Center - isECRecord Boolean
Keywords
Dependent, Related Person ID, orphaned person IDs, Delimit, Person Relationship Information, Related Person Id External, Child, parent, spouse, Husband, Import, Employee Central, Related Person Id External, Report, Canvas, Advance reporting, ODS, ROD, , KBA , report on dependent information , employee central , LOD-SF-EC-REP , Reporting Data (EC core only) , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , LOD-SF-EC-DPD , Dependents Management , How To