Build eLMIS 12 Key Reports (Excl Superset Enhancements)

Description

This ticket tracks building the 12 eLMIS reports into Superset. It does not include any functional enhancements we're building into Superset (popups in country map viz type, adding some new viz types, PDF printing, etc.), but captures 80% of the reporting content included in the eLMIS reports.

The eLMIS reports are:

  1. Stock Status Summary with Map Report: https://openlmis.atlassian.net/wiki/spaces/OP/pages/115189418/Reporting+-+Stock+Status+Summary+with+Map

  2. Reporting Rate and Timeliness Report: https://openlmis.atlassian.net/wiki/spaces/OP/pages/114327861/Reporting+-+Reporting+rate+and+timeliness

  3. Consumption Report: https://openlmis.atlassian.net/wiki/spaces/OP/pages/114328077/Reporting+-+Consumption+Report

  4. Stock Imbalance Report: https://openlmis.atlassian.net/wiki/spaces/OP/pages/114327981/Reporting+-+Stock+Imbalance+Report

  5. Facility List Report: https://openlmis.atlassian.net/wiki/spaces/OP/pages/114918245/Reporting+-+Administrative

  6. User Summary Report: https://openlmis.atlassian.net/wiki/spaces/OP/pages/114918245/Reporting+-+Administrative

  7. Order Item & Fill Rate Report: https://openlmis.atlassian.net/wiki/spaces/OP/pages/115189233/Reporting+-+Order+Item+Fill+Rate+Report

    1. For now, this report is built off of requisition data. However, Ashraf let us know we should look at basing it off of data from the Fulfillment Service in a future sprint

8. Logistics Summary Report: https://openlmis.atlassian.net/wiki/spaces/OP/pages/115188833/Reporting+-+Logistics+Summary+report

9. Adjustment Summary Report: https://openlmis.atlassian.net/wiki/spaces/OP/pages/115188949/Reporting+-+Adjustment+Summary+Report

10. Total Cost of Orders Report: https://openlmis.atlassian.net/wiki/spaces/OP/pages/115189326/Reporting+-+Total+Cost+of+Orders

The Order Summary Report is not included as it’s more of an order lookup and is not suited to come from an analytics database https://openlmis.atlassian.net/wiki/spaces/OP/pages/115189146/Reporting+-+Order+Summary

Acceptance criteria:

  • Charts built into Superset

  • Documentation mapping these charts to eLMIS reports

Activity

Show:
Done
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Story Points

Sprint

Fix versions

Affects versions

Priority

Time Assistant

Created September 13, 2018 at 7:10 AM
Updated January 29, 2019 at 7:20 PM
Resolved September 26, 2018 at 1:25 PM