Report and DR KPI Builder
From UG
(Difference between revisions)
(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.
