Internal Dashboard Reports (concepts and requirements) (OLD spec)

From UG

Revision as of 14:55, 22 April 2011

Info

Project Mantis: 0002488: [KPI]......... <proj>

Business Analysis and Requirements

Glossary

• Dashboard
• Dashboard Report

Summary

Right now the operations staff receives a number of scheduled reports via email daily. Currently these reports are scheduled according to office (by assigning a region, MOT (Ocean, Air, Trucking) if it is inbound (import) or outbound (export). So the NY Import Department is receiving these reports listing ALL NY import shipments - Ocean. Marc has requested these reports be personalized and added to dashboard reports.

Core need

To add a number of Dashboard reports for internal users.

Core functionality

• Take some existing reports and create Dashboards for them.
• Personalization. Make specific reports instances configurable in Admin. For example, Sue would see only in transit dashboard report for CTs for the client she handles. On the other hand John her manager would see in transit report for all clients (E0) that his team is managing.
• Easy management. Ability to map one report to a group of users.
• Extra filters. Might be required to add extra flexibility for report conditions.

NOTE: There is a similar component for internal reports / KPIs. See 0002932: [KPIs] ...... <proj>

Details

Controlling these reports

These reports should be controlled in Admin.

With the ability to disable if necessary

Add these reports to a Dashboard report

Dashboard should have one column listing the name of the report

For Example:
NY - Past Due Arrivals - Ocean - General Import 
of
NY - Past Due Arrivals - Coty

Dashboard should have another column showing the total number of shipments count on this report.

• This number should be a hyperlink, that would open up a report. Depending on the report, it may have another level of drop down.

For Example
NY - Past Due Arrivals - Ocean - General Import   Total Shipments 4
after clicking the hyperlink, the next report would only list the client name and total number
of shipments past due for that client.  This number would also be a hyperlink.
Space NK  2
Nassau Candy 1
Artcraft Health 1
After clicking the hyperlink, the next report would be an excel spreadsheet listing all the  details of those shipments
(including all the details that are currently on the "Past Due  Arrivals - Ocean report") 

Dashboard should provide real time updates Once the report is added to the dashboard, the system should no longer email the report to the operators.

• May need to add flexibility where you can select dashboard or email per user, if you are coping a Jaguar User in on a scheduled client report.

Personalization

The

General idea for Dashboard Report

TBD

Past Due Report Dashboard Report

TBD

Impending Arrivals Dashboard Report

Implementation Notes

Pre Implementation Architect Notes

Written by Architect after previous section is completed.

Implementation Notes

To be written by Developer or BA by the time UAT is completed. Briefly defines what was implemented and how.

Post Implementation Architect Notes

Written by Architect after previous section is completed.