OSP-24-REQ-RPT

OSP-24-RPT-01 - Create library of report templates for data from OSP tools. These will be delivered with the documentation, tentatively by the end of March.

• OSP Report Template Library, including reports on data from forms, wizards, and portfolios.
• Sakai Report Template Library, including reports on data from assignments and other Sakai tools. (out of scope for OSP)
• Usage Report Template Library, including reports on user activity, storage, and file types. (out of scope for Sakai 2.4)

  Sakai (1 issues)
  Status	Key	Summary	Assignee	Res	Updated
  Closed	SAK-7555	Create library of report templates for data from OSP tools, Sakai tools, and data on system usage in the following order of priority.	Unassigned	FIXED	Oct 23, 2008

OSP-24-RPT-02 - Clear documentation for the creation of report templates
DBA/XML/XSLT developers need clear documentation for the development of reports based on user requests.

• Use cases to determine report parameters, fields, and layouts and allow developers to easily create report templates
• Information on how to specify which roles can run reports on all sites or only sites in which they have membership.

  Sakai (1 issues)
  Status	Key	Summary	Assignee	Res	Updated
  Open	SAK-7556	Clear documentation for the creation of report templates	Sean Keesler	UNRESOLVED	Oct 23, 2008

Documentation requirements for the OSP Report tool.

The documentation for the OSP 2.4 report tool will provide step by step instructions for 3 audiences:

1. End users (Program Coordinators, faculty, deans, system administrators) that may want to request and view reports
   1. This section will inform end users about what the report tool is capable of doing, its limitations and strengths and how it fits in with other OSP/Sakai tools.
   2. This section will help a non-technical user to be able to be able to articulate their needs to a Report Developer, including:
      1. what data they want to include in the report
      2. the display format for the data
      3. how often the report should be run and by whom
      4. access, dissemination and publication requirements for the report results
2. Report developers (XML developers and/or DBA's)
   1. This section will document:
      1. Some ethics and privacy concerns to be considered
      2. Steps and files needed for a "Hello World" report, including:
         1. Reports configuration and definition files (or whatever they are going to be in 2.4)
         2. Report results files
         3. XSL files for the desired format
         4. Implementation
3. System Administrators and IT managers
   1. This section will contain:
      1. Some ethics and privacy concerns to be considered
      2. Time estimates and staffing suggestions for tool use

OSP-24-RPT-03 - Report templates

• Development of functionality within the reports tool to allow the creation of report templates using .xml and .xsl for users to use in running reports.
• Creation of new report templates will not require direct access to the server or a server restart.
• Users with permission can sort the list of report templates to locate appropriate reports to run.
• Users with permission can set query parameters through a user friendly interface.
• Reports will be goal aware allowing users to run reports of goals associated with various data structures.

  Sakai (1 issues)
  Status	Key	Summary	Assignee	Res	Updated
  Closed	SAK-7557	OSP-24-RPT-03 - Development of functionality within the reports tool to allow the creation of report templates	Unassigned	FIXED	Oct 23, 2008

OSP-24-RPT-04 - Intuitive interface to schedule and store reports

• A calendar tool will be created to facilitate setting the schedule for running reports.
• Documentation will be included for running reports and scheduling runs of reports.
• There will be designated folders for user create for the storage of reports.

  Sakai (1 issues)
  Status	Key	Summary	Assignee	Res	Updated
  Closed	SAK-7558	OSP-24-RPT-04 - Intuitive interface to schedule and store reports	Unassigned	FIXED	Oct 23, 2008

OSP-24-RPT-05 - Share, publish, and disseminate report results

• Users with permission will be able to share reports with selected viewers via username, email address, public URL, or through the Resources tool.
• Users with permission will be able to export the report results (CSV, Excel, etc...)
• Users with permission will be able to view the results in various presentation formats.

  Sakai (1 issues)
  Status	Key	Summary	Assignee	Res	Updated
  Closed	SAK-7560	OSP-24-RPT-05 - Share, publish, and disseminate report results	Unassigned	FIXED	Oct 23, 2008