Operational Data Store

1

• Operational Data Store
• Version 8 Testing
• February 18, 2009

2
Wanda Dixon and Coni Barlow
Business Intelligence and Reporting Team

• Presented By

3
Agenda

• Documentation
• How to get to test system?
• What to test?
• What to do if there are problems?
• Q A

4
Documentation

• Standard Certified (SCR) and High Usage reports
  tested by BIRT
• Advancement reports
• Finance reports 
• Human Resource reports
• Student reports
• Business Intelligence and Reporting Team
• Summary of Operational Data Store 8 Enhancements
• Banner Operational Data Store
• Release Guide 8.0- April 2008
• Handbook Release 8.0 - May 2008

5
How to get there

• Use following url to access Cognos under ODS
  Version 8 http//reportnetpp.wayne.edu/crnods8/cg
  i-bin/cognos.cgi
• ODBC users must add TNS entry into TNSNAMES.ora

ODSPP8.WORLD   (DESCRIPTION
   (ADDRESS_LIST      (ADDRESS
       (PROTOCOL TCP)        (HOST
odspp8.bes.wayne.edu)        (PORT
4080)       )     )     (CONNECT_DATA
      (SERVICE_NAME ODSPP8.WORLD)       (UR
A)     )   )
6
What to test?

• All departmental internal and shareable Cognos
  reports
• All departmental processes that use ODS views via
  ODBC (i.e. Microsoft Access, other desktop
  reporting tools)

7
Problems?

• How do I report a ODS 8 report or query problem?
• To submit a call tracker ticket, go to 
• Cognos E-Report Trouble Shooting Form

8
Questions
9
Questions
10
Questions
11
Questions