Analytics Reports MAIN WIKI
From UG
Info
0003003: (Analytics Reports) Create a module to produce this type of reporting
Core need
- We want to automate generation of special class of xls reports ("Utilization and Cost Saving Modeling reports"):
- based on CT2 database data
- Complex: mulitab, mix of graphics and tables on one page
- Normally related to utilization rates and costs, times
- 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
- see 2 examples (in 0003003)
- one of the examples is well defined in TMS Monthly Stats Report