Superset Training

Schema

Flatten into four requisition tables, base tables
Create three materialized views from which the indicators are built, from base tables
All charts and dashboards can use the materialized views
The materialized views were created for the three requisition reports identified in Gap project

Indicator Queries

Created dashboards

Superset is not a report building tool, but a dashboard building tool

Report vs. dashboard

Can download a CSV from a SQL query

Superset overview

Translations

New dashboard labels would have to be manually updated in Superset
Only supports one label per column, we would have to choose one language for the dashboard

Materialized views continued

reporting_dates is populated using a CSV
Can add default filters in Edit Dashboard in JSON metadata
Row level filtering
- Takes OpenLMIS permission strings and builds a table (facility_access)
- Used to filter by putting it in the SQL where clause, but now done in the Superset slice parameter

Users and Roles

Roles
- Admin - all
- Alpha - power user
- Gamma - regular user, no access to data sources
- As default, we use modified version of Gamma (OLMIS_Gamma), gave it access to all data sources in db (only be able to view charts built off those data sources)
Out of the box, Superset does not restrict which dashboards are viewable, it restricts dashboards based on the data sources it uses
OpenLMIS users access through OpenLMIS report screen, but it looks like currently shows the top nav bar
When the user is added into OpenLMIS, they may not be able to access Superset reports for a week, because the refresh is currently happening every 7 days

Dashboards and charts building

Multiple visualization types available (over 40)
Filter box is also a chart type, associated with a data source, should filter off same data source as chart

OpenLMIS