Schema
Data Model for Requisition-based Reports
- 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
- Report is entering parameters, then running a report
- Dashboard is seeing all of the data immediately then filtering as needed
Can download a CSV from a SQL query
Superset overview
- Sources → Tables, to see a list of tables in the postgres db
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