Symptom
How to build a workflow report adding the Workflow Current Step Owner First Name and Last Name?
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
- Successfactors HCM Core
- Advanced Reporting
- Report Center - Canvas Report
Reproducing the Issue
Create a Workflow Report in Advanced Reporting
Step 1: log in to the instance > Analytics - Advanced Reporting / (Report Center - Report Canvas)
Step 2: Select Workflow from the list
- Workflow
- Workflow Wf Request
- Add fields such as
- Add fields such as:
- Created By (Legal Last Name)
- Created Date
- Current Step Num
- Status
- Wf Request Id
Step 3: Workflow Wf Request > Current Step Workflow Wf Request Step
Select Workflow Wf Request > Current Step Workflow Wf Request Step
Add fields such as:
- Current Step Action Type
- Current Step Last Modified By (First Name)
- Current Step Last Modified By (Legal Last Name)
- Current Step Owner Id
- Current Step Status
In this table there is no: Current Steps Owner First Name or Current Steps Owner Last Name
Cause
The Current Steps Owner First Name or Current Steps Owner Last Name are found in the Global Job Information Table moving to the right of the: Workflow Wf Request > Current Step Workflow Wf Request Step.
Resolution
Do all the above 3 steStep and add the next step (4)
steps 4: Workflow Wf Request > Current Step Workflow Wf Request Step > Current Step Owner: Current Step Owner Global Job Information
Add the following steps:
- Current Step Owner First Name
- Current Step Owner Last Name
- Current Step Owner Person Id
- Current Step Owner Users Sys Id
The Result will show all the information related to the Current Step Owner from the Global Job Information
Please view : Employee Central Advanced Reporting Implementation or Employee Central Workflows: Implementation and Administration
See Also
- 2079915 - About Workflow reporting - Employee Central
- 2600713 - How to build a workflow report adding the Workflow Current Step Owner First Name and Last Name?
- 2376402 - Reporting on Activity Log for Workflow Changes / Manage Workflow Request - Advanced Reporting
- 2679275 - Where to find the latest version of Canvas Report Templates and corresponding documents?
- 2343620 - How to report on Workflows using Canvas / ORD reports?
- 2274688 - Workflow Reports - Employee Central
- 2079915 - About Workflow reporting - Employee Central
Keywords
Report, Workflow, Current, Owner, information, show, First, Name, LAst, Online, Designer, Canvas, Center, Advanced Reporting, work, flow , KBA , LOD-SF-ANA-ORD , Online Report Designer , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , LOD-SF-EC-REP , Reporting Data (EC core only) , Problem