Report and DR KPI Builder

From UG

Contents 1 Info 2 Core need 3 Notes from Solution Architect 4 Detailed Needs and Requirements 5 Solution version 1

Info

• 0003183: (* DR/KPI) Create "Report and DR/KPI Builder (RDB)" (phase 1)

Core need

Below is formulated by Marc and recorded by Alex.

• A. [need#1] We want to automate generation of special class of xls reports:
  • based on CT2 database data
  • Complex: mulitab, mix of praphics and tables on one page
  • Normally related to utilization rates and costs
  • Used as a tool for modeling of how to tweak different parameters such as transit times and utilization rates to reduce costs
  • Challenge is that every time we need to pull fresh data and apply formulas and charts
  • we also want to have “in system” version of these reports
  • we can provide 2 examples
• B. [need#2] We want to have multiple DRs/KPIs in the system
  • See specs for Arden cost per pound, Cost per unit, etc
• C. [need#3] Please consider both needs at the same time and create one solution that would address both (if possible).

Notes from Solution Architect

Is to create as universal as possible DR/KPI (*and Report) builder.

* Tracie added this requirement.

Detailed Needs and Requirements

Solution version 1