Report and DR KPI Builder

From UG

(Difference between revisions)
Jump to: navigation, search
(Created page with 'Category:DRs and KPIs == Info == * 0003183: (* DR/KPI) Create "Report and DR/KPI Builder (RDB)" (phase 1) == Core need == Is to create as universal as possible DR/KPI (*…')
Line 6: Line 6:
== Core need ==
== 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.
Is to create as universal as possible DR/KPI (*and Report) builder.
Line 11: Line 30:
''* Tracie added this requirement.''
''* Tracie added this requirement.''
-
== Detailed Requirements ==
+
== Detailed Needs and Requirements ==
== Solution version 1 ==
== Solution version 1 ==

Revision as of 18:58, 30 September 2011


Contents

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

Personal tools