MS Excel's pivot tables are used extensively with DHIS 1.3 for analysis of data. Dynamic cross-tabulating and drill-downs are popular features that are useful to the health information officers. Moving away from the Microsoft platform we need to find Open Source alternatives to the functionality of Excel. The functional requirements for the pivot table module shall be the same as the ones present in Microsoft Excel's pivot tables. Preferably this module is integrated into (at least started from within) the core module. Possible technologies are the OpenOffice data pilot which to a large extent provides the same functionality. The OpenOffice architecture is open and designed for add-ons and adjustments. The source code is available so, if necessary, it should be possible to adapt it to meet the needs of DHIS 2.0.

Project deliveries

Project delivery 1 DHIS-2.0-PIM-ALPHA (7.March)
Project delivery 2 DHIS-2.0-PIM-ALPHA-2 (4.April)
Project delivery 3 DHIS-2.0-PIM-ALPHA-3 (27.April)
Project delivery 4 DHIS-2.0-PIM-BETA (15.June)

Requirements specification

Desktop pivot module - pivot table (data pilot) analysis - general OLAP functionality - graphical presentations
PIM Datapilot

Jira tracking

Technology documentation

Open Office integration

Started to collect information on how to integrate with Open office.
http://api.openoffice.org/docs/DevelopersGuide/Preface/ReadersGuide.htm
http://development.openoffice.org/index.html#JAVA
Open office 2.0 SDK http://api.openoffice.org/servlets/NewsItemView?newsItemID=273

Example of using Datapilot component:

http://api.openoffice.org/source/browse/api/odk/examples/DevelopersGuide/Spreadsheet/SpreadsheetSample.java?rev=1.5&content-type=text/vnd.viewcvs-markup

Open office xml specification

http://xml.openoffice.org/xml_specification.pdf

Howto integrate and extend openoffice

http://api.openoffice.org/docs/DevelopersGuide/Components/Components.htm

Open office datapilot

Howto create a Open office datapilot connection with a dhis 1.3 datamart access db.

PS! nice little feature to add components to openoffice:
unopkg gui (Starts a grapichical user interface in order to add new packages and components)

Getting started

project setup

svn co svn+ssh://<username>@cvs.dhis.hisp.info/home/projects/dhis/scm/dhis-pim

Contact information

Per Thomas Kraabøl (pertk at ifi dot uio dot no)
Kai Fredriksen (kaifr at ifi dot uio dot no)