KPI

From UG

Revision as of 15:27, 25 May 2012

Info

• mantis parent: 0003545: [ DR KPI Phase I ) ..... <parent mantis >]
• mantis category: DR/KPI:ph1
• lead SA/PM: Alex
• lead Dev/Architect: Sasha

Requirements

• This Phase One should include first portion of DRs/KPIs delivered
• Must be production quality
• This phase is for Arden only (all MOTs)
• More phases will follow shortly that would be for other E0 Clients
• This project is very important top visibility project
• Also right tool/lib should be evaluated/selected for the future (example: LogiXML vs ZK API/other Java APIs)
• due dates:
  • production - end of June
  • vendor/libs evaluation - TBD

Solution

DR1 Simple Shipment count DR

• this DR should appear within panel on KPI Dashboard ("KPI" link form CT2 Client Header)

• requirements:
  • DR panel has two filters:
    • (Client E0) - single select;
    • Created on date (from date to date).
  • Below is radio ("Shippers"-default vs "Consignees" )
  • Below is radio (bar chart-default vs pie)
  • Below is parameter: "Display top <textbox>" (for example 5)
  • Below is graphics
  • axis X: 6 bars for top 5 (as far as number of CTs) Shippers (or Consignees) with labels and 6th represents all remaining Shippers/Consignees
  • axis Y: Number of CTs (for selected E0, for specific Shipper/Consignee)
  • User can change filters/controls and system will re-draw plot on the fly

• must be integrated seamlessly from:
  • look and feel experience (should blend in CT2 Client front end)
  • security (display only dashboard allowed for particular user)
    • QA test: assign one KPI to one user, one to another and verify what they see
  • parameter for report should be controlled through user profile and DR panel
    • number 5 should be a default parameter in user profile
    • also user should be able to change it on the screen and system would re-draw

Post Impl Notes

DR2 Complex Shipment Data per Client per Year DR, PART A

DR2 General Info

• DR2 should appear in "the standard ZK panel" (on homepage or on "KPI dashboard" - see "KPIs" link in top menu on Client) (not tab).
• DR2 should be available as option in user profile (on/off).

DR2 Mock Up

DR2 Left panel

• Client Company

if on internal then show all E0; if on Client show all after visibility rules are applied

• Year

use Ct#Actual_Delivery_Date

• MOT

Air, LCL, FCL(AW), FCL(MLB)

• Country type . Options:

origin - (use country in Shipper)

destination - (use country in Consignee)

DR2 Air by Ocean comparison table

• Ocean - combine LCL and FCL
• Regions - as defined in CT2

DR2 Tab1 Top Shippers, Consignees

Re-use #DR1 Simple Shipment count DR

DR2 Complex Shipment Data per Client per Year DR, PART B

DR2 Tab2

TBD

DR2 Tab3

TBD

Work breakdown structure and Change Requests

Dependencies

• 3567, 3575 are in parallel

3567 Rapidly Create Simple Shipment count DR using just ZK libs and java libs

• Mantis: http://ct.jaguarfreight.com/mantis/view.php?id=3567
• Dev: Sasha

Prove that it is possible to Rapidly Create #DR1 Simple Shipment count DR using just ZK libs / java libs.

3575 Evaluate LogiXML

• Mantis: http://ct.jaguarfreight.com/mantis/view.php?id=3575
• Dev: Kostya