1. Creating and Administering Analytics and Reports for SCM
  2. How can I remove blank rows from analyses and reports that are based on the Product Management - Change Order Approvals Real Time subject area?

How can I remove blank rows from analyses and reports that are based on the Product Management - Change Order Approvals Real Time subject area?

To remove blank rows from reports and analyses that are based on the Product Management - Change Order Approvals Real Time subject area, and use approver-related columns, add these filters to the code:

(("Change Order Approval Details"."Optional Approver Flag" <> 'B')
AND ("Change Order Approval Details"."Assignee Type Flag" <> 'Y') 
AND ("Change Order Approval Details"."Route Step Line Stage Flag" <> 'Y'))

These are the details of the columns that are used in the filters:

  • Optional Approver Flag: This column returns Y when the user is an optional approver and N when the user is the approver. Enter B in this column to remove blank rows.
  • Assignee Type Flag: This column returns Y when the approver is assigned through a role to the workflow step and N when the approver is an individual user.
  • Route Step Line Stage Flag: This column is meant for filtering the rows as previously explained.