DHIS version 2.11 is out and we have some great features for you:
- Web-based pivot table: Allows you to create pivot tables with data aggregated along all data dimensions, including data element/organisation unit group sets. Data dimensions can be arranged freely on columns, rows and as filters. You can include totals and subtotals on all axis and control the table density and font size under options. Your pivots can be saved as favorites and downloaded to your local computer. This design goal is to allow users to create their own reports with the data they need without any involvement of super-users.
A pivot table with immunization indicators for last 4 quarters by facility ownership, type and location can be made like this (log in with admin/district):
A pivot table with number of diagnosis by facility ownership and type with totals and subtotals looks like this (notice that diagnosis are data element groups):
A pivot table for vaccines, broken down on categories, age group and point of service, last 12 months:
A pivot table with reporting rates, major forms for public facilities by location and type, last 12 months:
We encourage you to play around - select dimension items for the left menu and arrange dimensions from “Layout” in the top menu. Documentation can be found here:
- Data analytics Web-API resource: A flexible API for retrieving aggregated, analytical data for all data dimensions using a simple query syntax. The pivot table module is built on top of this API. It allows developers of third-party apps and web portals to connect to DHIS 2 and query for any type of aggregated data, where any number of dimensions and filters can be specified. Data can be retrieved in json, jsonp, xml, csv, html and xls (Excel) format and responses can be constrained with criteria like greater than, equals and so on.
A query for retrieving data for certain data elements, periods and organisation units might look like this:
Documentation can be found here:
- Sharing: Several objects including chart, pivot table, map, indicator and data set can now be shared and have fine-grained access control. An object can be made private to yourself, shared with any number of user groups or be made available for all. You can grant edit or view-only rights to other people. You can create user groups directly from the dashboard. Who should be allowed to create public objects can be controlled through user roles.
This functionality is useful for example in a scenario where entities like health programs and implementing partners need to create indicators and reports which should be available only for members of their organisation. In this case, an organisation can create a user group for their staff, then develop charts and maps which could be made available for that organisation only. General reports made by the ministry could still be shared with all and made publicly available.
Another use-case is that of an international NGO with operations in multiple countries. Here, user groups could be set up for each country and indicators, resources, charts and reports which are country-specific could be made available for staff working in that country only, without appearing in lists for staff working in other countries. Indicators and reports which are applicable for all counties could be made accessible for all. The sharing solution also opens up for great possibilities when combined with the self-registration of user account feature.
- DXF 2 meta-data exchange: You can now import and export a complete set of objects in the aggregate part of the system, including data sets, custom data entry forms, maps, charts and option sets. Import/export of meta-data objects now uses the new DXF 2 format. Import/export can also be done through the meta-data Web API resource. This greatly improves the ability for meta-data exchange between DHIS 2 instances and third-party systems.
An example of such a report can be viewed here:
- Multi-organisation unit data entry: You can now do data entry for multiple organisation unit in the same form. This is useful for instance in scenarios where you have section forms with few data elements and an organisational hierarchy with hospitals with multiple wards below, as it allows you to do fast data entry for all wards at the same time. To enable it, go the system general settings and enable “multi-organisation unit forms”, then go to data entry and select the organisation unit above the ones you want to enter data for.
- Tracker ad-hoc aggregate reports: You can now do on-the-fly aggregation of tracker data in tabular reports. Define aggregation queries with filters or group statements and view the results instantly. Create reports like top 10 diagnoses from inpatient admissions, save as favorite and run the report again whenever you like. You can check it out here:
- Tracker program statistics reports: Tracker now comes with better out of the box statistics to program managers. Monitor new enrollments, programs completed, and drop-outs. Also analyse in detail from each stage how many visits are done, completed and overdue. Try it out on the demo here:
- Tracker general improvements: The tracker module is rapidly being improved and the user experience is improved in person dashboard, case-based tabular reports, person aggregation and program maintenance.
The tracker user guide can be found here:
- Facility registry Web API resource: DHIS 2 now implements the API specification made by the FRED project. This means that DHIS 2 can be considered a feasible facility registry. More info here:
Model changes: Indicator formulas, validation rule formulas and custom data entry forms are now using UIDs (stable identifiers) which makes it possible to transfer these easily between systems. Category options can now be re-used within many categories which improves analysis and naming conventions.
Miscellaneous: Report table supports weekly periods. Data visualizer has an improved favorite user interface, making it consistent with pivot table and GIS. Touch-friendly navigation for help and profile items (click on help or profile in top menu).
- The scheduling functionality has been improved. As a consequence you must re-set your scheduled jobs after upgrading in data administration -> scheduling.
WAR file, Live package, sample data and source code can be downloaded from here:
Documentation and Javadocs can be found here:
Launchpad source code page:
Launchpad blueprint page:
the DHIS 2 development team