SAP Knowledge Base Article - Public

2848243 - Position data joined to the Workflow object is blank - Advanced Reporting

Symptom

  • Position data joined to the Workflow Wf Request Step table is blank in Advanced Reporting.
  • Workflow table is not findable as a related table.

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 on Advanced Reporting query

Reproducing the Issue

  1. Create a report in Advanced Reporting
  2. Select the Workflow category
  3. Drag and drop the Workflow Wf Request Step object to the query
  4. Search for the Position object
  5. Drag and drop the Position object to the query
    wf-position.png

  6. Check the results
  7. The data from Position is blank

Cause

Reporting of the content of workflow request is out of the scope in Advanced Reporting. By default the reports are based on committed = approved data.

Resolution

If you need to report on Position and Workflow data, the query needs to be created in a different way: the Driving Table of the query has to be Position. From there a join to GO_Wf_Request => Workflow Emp Wf Request => Workflow Wf Request => Workflow Wf Request Step => …. Is needed to derive the workflow data (e.g. when the workflow(step) was created/processed by whom, for how long the approval step is pending, etc.). You might filter for pending / rejected / approved positions (mdfRecordStatus = P/PH, N) depending on the specific report requirements.

position-wf.png

Note: For MDF objects that use the MDF workflow, it's the prerequisite to have a join to GO_Wf_Request. This join is available for some MDF objects like Position, Payment Information, Benefit Enrollment, Benefit Claim. However, we cannot report on the content of workflow requests based on non-MDF objects like jobInfo, personalInfo and other tables. Reason is the structure of the table "Workflow Wf Request attributes" that stores the content of the workflow request is not "normalized", i.e. there are fields like Attr Key, Attr Value and Category. This prevents to define a join to the respective non-MDF objects

See Also

 2682975 - Pending workflow details in advanced reporting - Advanced Reporting

Keywords

Position, data, joined, empty, canvas, ord, information, Workflow, object blank, Advanced Reporting, Cannot find workflow table , KBA , LOD-SF-ANA , Analytics & Reporting (Ad Hoc, YouCalc, ORD) , Product Enhancement

Product

SAP SuccessFactors HXM Suite all versions