Question

2
Replies
1833
Views
voonkeongl Member since 2017 12 posts
Kelly Services Malaysia Sdn. Bhd.
Posted: 2 years ago
Last activity: 2 years 5 months ago
Closed
Solved

Report optimization for performance

You have been asked to create a list report that displays the following information: -Assigned case worker (.pxAssignedOperatorID)
-Requestor (.pxCreateOperator)
-Request date (.pxCreateDateTime) -Due date (.DueDate)
-Assigned vendor (.VendorName) The report contains two filters:
-Return purchase requests with a status (.pyStatusWork) of open.
-Return purchase requests when a department (.Department) matches the user’s department (.pxRequestor.pyUserIdentifier).
Which property, if not optimized, has the greatest impact on report performance?
Department / .DueDate  .pxRequestor.pyUserIdentifier  .VendorName
May I know what would be the best answer for this question? I think it's Department but I am not sure. Thanks
Reporting
Moderation Team has archived post
Share this page LinkedIn