SAP Knowledge Base Article - Public

2806252 - How To Retrieve Dependents Related Information via Canvas Reports

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

  1. Go to Report Center
  2. Click on Report Canvas -Then Select
  3. Give your report a name
  4. Mouse over table
  5. Click table and Drag down 

9dependent.png

  1. Click on: Edit Query
  2. Select Advance Reporting
  3. New
  4. OK

11Dependent.png

Step 1: Select Parent or Root table

  1. Person
  2. Select Person Child Table Personal Information
  3. 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

  1. Dependent Personal Info
  2. Select and drag Dependent First Name - Dependent Last Name 

Step 3:

  1. Save Report
  2. Click Objects and View Report overview 

See

18Dependent.png

Filter EC user

  1. Click on:Manage Filter Query
  2. Select User ID
  3. Save Report

6dependent.png

View Report Result

  1. Click Results
  2. Related Person ID displayed for EC User Dependent

5Dependent.png

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

  • 2368375 - How to Set Up and Use Date Options in Advanced Reporting
  • 2776882 - EC Advanced Reporting Metadata Sync / Reload (View Based Metadata)

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

Product

SAP SuccessFactors Employee Central all versions ; SAP SuccessFactors HCM suite all versions