Introduction
In addition to a desktop pivot table module there is a need for a web-based module providing the same basic functionality as the desktop version. There are some limitations to web based pivot tools such as the drag and drop functions. However, the most important pivoting functions such as drill-downs and slice-and-dice are possible also in web environment.
There are two alternative approaches to developing a web-base pivot module:
1. There is already a web-based pivot tool developed by HISP, an .ASP web application supporting Access and SQL Server. This again demands the Microsoft platform, however just at the server side.
Porting the Pivot Web reporter (and the linked web portal) to a Java environment would be a great challenge. On the one hand it means working on a relatively advanced application with major opportunities within performance optimization, web lay-out and printing, etc - on the other hand you would have the existing .ASP application as a broad road-map and thus be less dependent on advanced users.
The Pivot Web Reporter initially was developed for dynamic corporate reporting - it's used by one of the largest companies in South Africa and it can easily be adapted to other environments and DBMS platforms since any database can be configured through a relatively simple XML-file to function as a data source.
2. Use the Open Source Java tool called jPivot
. JPivot is a JSP custom tag library that renders an Online Analytical Processing (OLAP) table and let users perform typical OLAP navigations like slice and dice, drill down and roll up. It uses Mondrian (also OSS) as its OLAP Server.
For new developers to the webpivot group we suggest you to read the Guide for new developers to the Webpivot module for more information about the module.
3. Also look at the broader reporting efforts within HISP: The work on report generation using Jasper Reports, the work on BIRT, and perhaps most importantly, Pentaho
Development
Latest news
Older news
Developers
| Name |
Cellphone |
Mail |
Msn |
| [~babrodtk] |
xxxxxxxx |
xxxxxxxx.på.xxx.xxx.xx |
xxxxxxxxxxx.på.xxxxxxx.xxx |
| [~paalvk] |
xxxxxxxx |
paalvk.på.ifi.uio.no |
xxxxxxxxxxxx.på.xxxxxxxx.xxx |
| [~mariafo] |
41500814 |
mariafo.på.ifi.uio.no |
foss_marianne.på.hotmail.com |
| [~hannemoe] |
xxxxxxxx |
xxxxxxxx.på.xxx.xxx.xx |
xxxxxxxxxxx.på.xxxxxxx.xxx |
| [~guom] |
97075367 |
guom.på.ifi.uio.no |
dj_bryan54.på.hotmail.com |
| [~kjetilos] |
41696877 |
kjetilos.på.ifi.uio.no |
kjetilos.på.gmail.com |
- The e-mails have been made unreadable to spam scripts
Developer meetings
We have weekly developer meetings in person. These meetings are held at IFI, Friday at 10:00 am. The meetings will be canceled if there is nothing of importance to discuss. But every developer must be able to meet at these times in order for us to resolve possible issues efficiently.
Reports from group meetings can be found here.
Progress / roadmap
Source code
The source code can be downloaded with Subversion.
Our project source code can be checked out with:
The source code for the whole DHIS-2 project can be checked out with
Building the project
The project can be built with Maven.
You can build it with
from the directory in which the source code is.
Dependencies
Jetty
You might need to install Jetty into your local repository. For a how-to, take a look at this page.
xwork-optional
You might need to install this as well into your local repository. Take a look at xwork-optional to see how.
jdbc driver
You might need to install this as well into your local repository. Take a look at JDBC to see how.
Project Documentation / Research
Useful resources/links
JPivot
WebWork
DHIS
Database
