Reports Breakout Group

Proposed OSP 2.6 Reporting Requirements (in order of priority)

  1. Create a sample artifact report definition to use in accessing student artifacts by means of specific parameters and/or random selection of users or user artifacts in relation to specific parameters - Low Effort
  2. Put existing administrative and OSP tool sample report definitions in OSP Library along with links to documentation for each report in Sakai Confluence. Documentation will include purpose of report and how to implement report. - Medium Effort - http://bugs.sakaiproject.org/jira/browse/SAK-10321
  3. Create report pagination at the data level (rather than code level) to allow users to click through report data one page at a time. - Low to Medium Effort - http://bugs.sakaiproject.org/jira/browse/SAK-10320
  4. Provide ability to export and import report definitions. - Medium Effort
  5. Document the OSP Data Warehouse using a data model relationship to describe the data structures and facilitate the integration of internal data with external data from student information systems. - Low to Medium Effort - http://bugs.sakaiproject.org/jira/browse/SAK-10318
  6. Allow parameters to be passed between OSP report definitions (linked/drill-down reports). - Low to Medium Effort - http://bugs.sakaiproject.org/jira/browse/SAK-10320
  7. Identify and integrate a Report Builder facilitating selection of available parameters for building of specific reports. Initially limit Report Builder access to system admin to avoid data security issues. - Effort depends on Noah Botimer's progress in working with BIRT functionality.
  8. Provide a POI to export all report results directly to MS Excel. - Low Effort
  9. Provide ability to batch export subsets of artifacts to zip files - Low Effort
  10. Create documentation for writing .xml report definitions and add to Sakai Confluence. - Medium Effort (Will Trillich volunteers for this task.)
  11. Create a security level to allow specified high level administrators to access the Report Builder. This requirement might benefit by association with a GMT security requirement. - Medium Effort
  12. Optimize OSP Data Warehouse so that it takes less time to run with large amounts of data. - High Effort - http://bugs.sakaiproject.org/jira/browse/SAK-10316
  13. Write plug-ins to expose the data from specific tools (goal management/assignments, discussion, chat, etc.) to queries from reports. Consider using BIRT access to all live data in the Sakai api. Effort depends on Noah Botimer's progress in working with BIRT functionality.