Report and DR KPI Builder

From UG

Revision as of 19:21, 30 September 2011 (edit) Alex (Talk | contribs) (→Notes from Solution Architect) ← Older edit		Current revision as of 23:53, 30 September 2011 (edit) (undo) Alex (Talk | contribs) (→Core need)
(12 intermediate revisions not shown)
Line 3:		Line 3:
	== Info ==		== Info ==
-	* 0003183: (* DR/KPI) Create "Report and DR/KPI Builder (RDB)" (phase 1)	+	* 0003183: (* DR/KPI) "Report and DR/KPI Builder (RDB)" (research if this option is feasible)
		+
		+	'''!!! This is related to Flex Report task: 0002608: [Flex Rep] Code this.''' http://ct.jaguarfreight.com/mantis/view.php?id=2608
	== Core need ==		== Core need ==
-	Below is formulated by Marc and recorded by Alex.	+	*A. see 3003 [[Analytics Reports MAIN WIKI]]
-	*A. [need#1] We want to automate generation of  special class of xls reports:	+	*B. see 3131 [[DR KPI Framework (for non AR 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).	+
		+	Please consider both needs above at the same time and create one solution that would address both (if possible).
	== Notes from Solution Architect ==		== Notes from Solution Architect ==

---

Current revision as of 23:53, 30 September 2011

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

[edit] Info

• 0003183: (* DR/KPI) "Report and DR/KPI Builder (RDB)" (research if this option is feasible)

!!! This is related to Flex Report task: 0002608: [Flex Rep] Code this. http://ct.jaguarfreight.com/mantis/view.php?id=2608

[edit] Core need

• A. see 3003 Analytics Reports MAIN WIKI

• B. see 3131 DR KPI Framework (for non AR reports)

Please consider both needs above at the same time and create one solution that would address both (if possible).

[edit] Notes from Solution Architect

• Tracie had a vision of a broader solution (wizard) that can create any report not only satisfy Marcs needs above . Call it DR/KPI and Report builder. I suggest to be careful to expand the scope so much.

I suggest considering options:

[A] Use Crystal Reports

• Pros: very flexible, can be coded quickly, produce professional looking reports (pdf), can start automating immediately
• Cons: some programming required most of the time, “in system” reports are not possible

[B] Use another existing framework (say Java library)

[C] Write our own “Reports/KPI builder”

[edit] Detailed Needs and Requirements

[edit] Solution version 1