...
- 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