A few weeks ago I mentioned that I was interested in doing a bit of freelance consulting for OSP. A couple people asked me if I was available/interested in doing work outside of OSP for Sakai in general. Of course, I am. The Reports tool (now core, like the rest of the OSP tools suite) seems to blur the boundaries between OSP and Sakai. In a nutshell, the reports tool allows someone to define SQL based reports that can be run against the live database or a set of data warehouse tables (you may have noticed a bunch of tables named "dw_xxxxx" in your instance). To complicate matters, much of the data related to portfolios are stored in XML on the file system and are therefore unavailable to the reports tool unless converted. The system is powerful, but poorly understood by the community and sparsely documented.

I have set up an account and a project at fundable.com to see what sort of interest the community has for this effort.

The Sakai Reports tool documentation needs improvement.

Many schools deploying OSP as a portfolio system want to use custom reports to aggregate data for institutional purposes. The reports that the community has included in the OOTB experience have little to do with the type of data that schools would actually want to report about. Building custom reports for your institution makes a lot of sense, but very few schools have been successful at it because they just don't know how.

I would be interested in investigating and writing related community documentation in Sakai confluence if anyone is interested in funding my independent effort to do so. My initial guess is that I will probably need to also document the job scheduler and the data warehouse in order to successfully move the documentation forward. While it is difficult to promise a "complete package" will result from my effort I feel that a few good interviews and some time devoted to understanding and disseminating the capabilities (and limitations) of the report tool functionality would benefit the entire Sakai community.