Business Intelligence and Reporting
This presentation is the property of its rightful owner.
Sponsored Links
1 / 9

Business Intelligence and Reporting www.reporting.wayne.edu PowerPoint PPT Presentation


  • 59 Views
  • Uploaded on
  • Presentation posted in: General

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

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Business intelligence and reporting reporting wayne 1324346

Business Intelligence and Reporting

www.reporting.wayne.edu

Computing & Information Technology

Operational Data Store

Version 8.1

September 2, 2009


Business intelligence and reporting reporting wayne 1324346

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


Documentation

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


Business intelligence and reporting www reporting wayne edu

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


How to get there

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)

  •     )

  •   )


What to test

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.


Problems

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.


Business intelligence and reporting reporting wayne 1324346

Business Intelligence and Reporting

www.reporting.wayne.edu

Computing & Information Technology

Questions


Business intelligence and reporting reporting wayne 1324346

Business Intelligence and Reporting

www.reporting.wayne.edu

Computing & Information Technology

The End


  • Login