Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Business Intelligence and Reporting www.reporting.wayne.edu PowerPoint Presentation
Download Presentation
Business Intelligence and Reporting www.reporting.wayne.edu

Business Intelligence and Reporting www.reporting.wayne.edu

98 Vues Download Presentation
Télécharger la présentation

Business Intelligence and Reporting www.reporting.wayne.edu

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Business Intelligence and Reporting www.reporting.wayne.edu Computing & Information Technology Operational Data Store Version 8.1 September 2, 2009

  2. Business Intelligence and Reporting www.reporting.wayne.edu Computing & Information Technology • Documentation • How to access the test system? • What to test? • What to do if there are problems? • Q & A

  3. Documentation Business Intelligence and Reporting www.reporting.wayne.edu Computing & Information Technology • 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.1 • Handbook Release 8.1

  4. Testing period: A four-week timeframe to test reports and verify queries will start on Thursday, September 3, 2009 and end on Wednesday, September 30, 2009 Townhall: September 30, 2009, 1-2:30 p.m. in 1700 AAB — Conclusion of testing period Implementation Date: A point upgrade (from 8.0 to 8.1) is scheduled to take place beginning on Friday, October 3, through Sunday, October 5. Business Intelligence and Reportingwww.reporting.wayne.edu

  5. How to get there… Business Intelligence and Reporting www.reporting.wayne.edu Computing & Information Technology • Use following URL to access Cognos under ODS Version 8.1: • https://ppreporting.wayne.edu/crn/cgi-bin/fe.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? Business Intelligence and Reporting www.reporting.wayne.edu Computing & Information Technology • Internal departmental and shareable Cognos reports that use the 17 changed ODS views. • Departmental processes that use the 17 changed ODS views via ODBC (i.e. Microsoft Access, other desktop reporting tools) • Primarily focus on the 17 out of the 580 views that changed. The changes are primarily in the Student area.

  7. Problems? Business Intelligence and Reporting www.reporting.wayne.edu Computing & Information Technology • How do I report a ODS 8.1 report or query problem? • Submit a call tracker ticket, by going to Cognos E-Report Trouble Shooting Form • Please include “ODS 8.1 Testing” in the “Report Name” field of the form.

  8. Business Intelligence and Reporting www.reporting.wayne.edu Computing & Information Technology Questions

  9. Business Intelligence and Reporting www.reporting.wayne.edu Computing & Information Technology The End