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

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

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

(("New Item Request Approval Details"."Optional Approver Flag" <> 'B')
AND ("New Item Request Approval Details"."Assignee Type Flag" <> 'Y')
AND ("New Item Request 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.