1 / 9

Business Intelligence and Reporting www.reporting.wayne.edu

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

grazia
Download Presentation

Business Intelligence and Reporting www.reporting.wayne.edu

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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

More Related