Question

2
Replies
1979
Views
Close popover
voon keong lum (voonkeongl)
Kelly Services Malaysia Sdn. Bhd.

Kelly Services Malaysia Sdn. Bhd.
MY
voonkeongl Member since 2017 12 posts
Kelly Services Malaysia Sdn. Bhd.
Posted: April 9, 2018
Last activity: April 11, 2018
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,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.