Student Reporting
Student reporting in Banner uses an operational data store (ODS), which extracts information from Banner administrative systems, organizes it into a simplified format, and stores the information in the ODS database where users can create and deploy operational and ad hoc reports.
The ODS provides an extensive, flexible data store and business organized reporting views with improved performance. It refreshes nightly.
Note: All Banner documentation and business concept diagrams are proprietary and should not be copied or distributed outside of Purdue University.
Contact the Cognos Student Reporting Team.
ODS Metadata
Since Purdue did not implement all the Banner modules, some information contains metadata and references to tables and views for which no data will be populated. For example, HR, Financials and Advancement modules are out of scope for this implementation.
- ODS Metadata Version 8.0 Upgrade Implemented June 15, 2009 (A valid Purdue Career Account is required to view this page.)
- Student Reporting Data Knowledge Base
ODS 8 Upgrade
Although this contains information about all SunGard Higher Education products, Purdue implemented only the Banner Financial Aid and Student modules. (A valid Purdue Career Account is required to view this document.)
ODS 8 Testing Instructions (June 1-12, 2009) (PDF)
ODS 8 Testing Rooms & Dates (PDF)
Student Reporting Resources
Operational Data Stores
- ODS Architecture (PDF)
- ODS Handbook (PDF) (A valid Purdue Career Account is required to view this document.)
Cognos
- What's New in Cognos 8.4 (PDF)
- Cognos Consumer Manual (PDF)
- Tool Tips
- Creating Multiple Query Reports (PDF)
- Cognos Summarization Tips (PDF)
- Cognos/ODS Translation Guide (PDF)
- Copying Cognos reports from the Cognos QA server to the Cognos production server (PDF)
- Using LOV tables in report prompts (PDF)
- How to renew Cognos credentials (PDF)
- How to schedule Cognos reports to email (PDF)