3040457 - How to report on the Name of the Dynamic Group from Workflow Requests - Canvas Advanced Reporting

• The Current Step Owner ID field returns blank data when the Current Step Approver Type is DYNAMIC_GROUP
• How to get the name or description of the dynamic group from Workflows in the Advanced Reporting query

SAP SuccessFactors HXM Suite
Advanced Reporting

1. Create a Canvas - Advanced Reporting query or Edit an existing Canvas Standard report for Workflow, e.g. Open Workflow Requests
2. Make sure that the Current Step Approver Type field is added from the 'Current Step Workflow Wf Request Step' object
3. Add a filter for Current Step Approver Type = "DYNAMIC_GROUP" for easier checking
4. Run the report or preview the query.

Result: Current Step Owner Id shows no data and the name of the Dynamic Group is not displayed.

Please see 2707583 - Current Step Owner and Workflow Step Owner Fields are blank in Advanced Reporting

DYNAMIC GROUP:

From the Workflow Requests side, Owner ID for a Dynamic Group step is not generated.  To derive the members of the dynamic group, it’s required to run the 3nd page of the 'Open Workflow Requests' standard report 'page 3 - Dynamic Group Member Assignment'.

To get the Dynamic Group name to show in the report

1.  From 'Current Step Workflow Wf Request Step'  add a join to Current Step User Users Group
2.  From Current Step User Users Group, select the field Current Step Users Group Name
   
   Current Step Users Group Name should return the name of the Dynamic Group.
   
   
   
   
   
   To validate, you can check the configuration of the workflow:
   
   

2707583 - Current Step Owner and Workflow Step Owner Fields are blank in Advanced Reporting

dynamic group name, report on name of dynamic_group, advanced reporting, workflow requests reporting, Current Step Users Group Name, DYNAMIC_GROUP, Current Step Workflow Wf Request Step , KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To