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

Assignee

Clay Crosby

Reporter

Clay Crosby

Labels

None

Story Points

3

Sprint

None

Fix versions

Affects versions

Priority

Major
Configure