Project Budget / Cost is not processed, so deviation view gives all project, and at design time it shows Problem on Project
Requirement is Just show Project which have deviation
End user will try to narrow down count on this View
Owners can see Problem Project and Take action Accordingly
Solution -
Show Projects that have problem
Deviation meaning is -
a. Project which are over Budget, that comes from Timesheet filled vs allowed Budget
b. Project which are over time, ie(NSIP is larger than allowed time on Service Page)
Budget and NSIP current standing should be calculated regularly on some frequency ie.(Weekly)
Technical details-
this is too much data to process on regular basis, ie(Pending Project count = 500 * All Accounting Companies 70) on single Server
We might create new system that process this on which timesheet is updated,
To stop frequent Updating, system cloud wait for 2 hour, if no timesheet is filled in last 2 hours then Update deviation metric on Project on which last timesheet is filled
this would prevent schedule base update deviation metric
NSIP should also need to be updated regularly,
NSIP must be done on schedule basis, because of no user related trigger to calculate days
Problem -
Solution -
Technical details-
Initially reported by - @vinpahilwani