DR KPI Framework (for non AR reports)
From UG
(Difference between revisions)
(→Level 3) |
(→Preliminary Fix Bugs) |
||
| Line 21: | Line 21: | ||
== Solution version 1 == | == Solution version 1 == | ||
| - | === Preliminary | + | === Preliminary works === |
| - | * make proper calculations on Level 1 | + | * need to fix known bugs to make proper calculations on Level 1 |
| - | * | + | ** including error message for "previous year" period |
=== Improve Design === | === Improve Design === | ||
Revision as of 13:45, 6 January 2012
Contents |
Info
- 0003034 (* DR/KPI) ....... <proj>
Core Need
To produce common approach (if possible) to multiple DRs/KPIs in the system
- See specs for various KPIs in Category: DRs and KPIs such as Arden cost per pound, Cost per unit, etc
- AR DRs (Action Required DRs are outside of this for now). See Category: Action Required DRs
Requirements
See these wikis:
- Cost per pound KPI (TMS based Arden ) (solution) - first version is in production
- Cost KPIs (cost per unit) (concepts and requirements) - BA completed
- KPIs_for_OpsTruck#Average_times_KPI - BA completed
Solution version 1
Preliminary works
- need to fix known bugs to make proper calculations on Level 1
- including error message for "previous year" period
Improve Design
KPI settings
- default Time Frame
- default Group By
- TBD
Level 1
- Fix bugs.
- TBD
Level 2
- Change list of indicators showed on Axis X - Time, Carriers, Consignees, Shippers
- Change "time period" dropdown - remove "Days" / Group By instead Axis X
- Show "Time Period" controls (now radio buttons) only for Time indicator
- Linear chart for Time, bar chart - for others
- Carrier and Truckers should be the same (now aren't)
- add "Download to Excel" button
Level 3
- breakdown on Group By
- add new KPIs and update list of Output Fields
- KPI overlapping - several KPI's in adjacent columns
