# olmis-analytics-malawi
Country-specific **analytics-extension** package for OpenLMIS Malawi, layered on top of openlmis-reporting (analytics-core) and consumed by the reporting-stack platform.
Extensions are additive only — they add new dbt marts and Superset dashboards but must not modify core models/dashboards or change ingestion contracts.
## Directory structure
```
olmis-analytics-malawi/
manifest.yaml # Package metadata (type: extension)
dbt/
dbt_project.yml
seeds/
malawi_program_products.csv # Static reference list: programs × products
# marked as essential in Malawi
models/
marts/
mart_malawi_requisition_by_region.sql
mart_malawi_stock_status.sql
schema.yml
superset/
assets/
metadata.yaml
databases/reporting_clickhouse.yaml
datasets/reporting_clickhouse/
mart_malawi_requisition_by_region.yaml
mart_malawi_stock_status.yaml
charts/ # 10 charts covering stockouts, stock levels,
# requisitions by region, programmatic snapshots
malawi_district_stockout_map.yaml
malawi_product_stockout_12mo.yaml
malawi_program_inventory_snapshot.yaml
malawi_program_stockout_trend.yaml
malawi_programmatic_stockout_pivot.yaml
malawi_requisitions_by_region.yaml
malawi_stock_levels_by_program.yaml
malawi_stockout_by_district.yaml
malawi_stockout_by_product.yaml
malawi_stockout_by_program.yaml
dashboards/
malawi_stockouts.yaml # Stockout focus across products/districts/programs
malawi_stock_levels.yaml # Stock-on-hand by program
malawi_regional_overview.yaml # Requisition counts by region/status
malawi_summary.yaml # Master Malawi dashboard: district map + pivot
# + 12-month trends
```
Note: extension packages do **not** include `connect/` or top-level `databases/` — ingestion configuration is owned by the core package. The `superset/assets/databases/reporting_clickhouse.yaml` here only re-declares the database for asset-import purposes; it must match the core package's UUID.
## dbt m …