DHIS 2.0 Milestone 4 (M4)
Release date: May 15 2006
New features
- Improved Import/export - Woinshet
- Datamart tables - aggregation of data and indicator values - Lars
- Pivot table templates for using Excel and OpenOffice.org - Per Thomas and Ola (will be provided by the end of May)
- User login and user admin - Duc and Torgeir
- New Data Element features: - Torgeir
- alternative name
- code
- possibility to sort DE by code
- New web portal plugin and improved assembling of web modules - Torgeir
(see DOC:The DHIS 2.0 web solution)
- Updated logging libraries (commons-logging 1.1) - Torgeir
Want to participate?
Please send an e-mail to the contact person if you want to join that task.
(see [Contact info] for addresses)
Specification
Aggregation and datamart tables
- Test and finalise the aggregation functionality
- Persist aggregated and calculated (indicators) values in the DAO layer
- This will facilitate easier and faster data access for all reports and analysis modules
- Also persist (or in other ways facilitate) easy access to hierarchy structure and the relationship between units (as in the DHIS 1.4 OrgUnitStructureOU'X' datamart tables)
- This is needed by e.g. pivot tables and reports that need both aggregated and disaggregated values (hence need the orgunit-parent-grandparent relationship between units to be mapped to a result set with the data value (as an example look at the PivotSource queries in the 1.4 datamart file, how the RoutineData tables are joined with the OrgUnitStructure tables)
Pivot tables
- Set up OpenOffice.org to work directly towards the DHIS 2.0 database and use the data pilot functionality in the Spreadsheet application to provide pivot tables for data analysis