150 likes | 351 Views
Discoverer Plus . Take your reporting to the next level. Discoverer Plus. This session will provide an overview of Oracle’s Business Intelligence data exploration tool called Discoverer Plus. Presenters:. Discoverer Plus.
E N D
Discoverer Plus Take your reporting to the next level Professional Development Institute 2009
Professional Development Institute 2009 Discoverer Plus • This session will provide an overview of Oracle’s Business Intelligence data exploration tool called Discoverer Plus. • Presenters:
Professional Development Institute 2009 Discoverer Plus • Oracle’s report writing tool that provides access to data in the Operational Data Store. • Intuitive, ad-hoc, query tool • Report creation and sharing • Reports with charts and graphs • Data analysis with drill-down capabilities • Report scheduling and export capabilities • Web based (no software needs to be installed)
Professional Development Institute 2009 Operational Data Store (ODS) • The ODS is a database that stores data in a central location for reporting and allows for integration of data from different systems. • The data in the ODS is refreshed nightly. Aries Discoverer ODS RamCT Access Nightly Refresh Excel Facilities Oracle Rpts. Other Tools HR
Professional Development Institute 2009 Discoverer Plus Terminology • End User Layer (EUL) • The EUL provides authentication and connectivity between Discoverer Plus and the ODS. • Business Area (BA) • BA’s are a collection of ODS data stored in views and they are assigned to a specific EUL. • Workbooks • Workbooks are Discoverer Plus files that contain worksheets displaying data retrieved from the ODS. • Worksheet • Worksheets contain the data that you want to analyze.
Professional Development Institute 2009 Discoverer Plus Demo • Live demonstration of Course Registration by College. • Discoverer Plus (ODS Test)
Professional Development Institute 2009 Discoverer Plus Training • Training will be available through CTSS. • The next training session will begin January 21st. • All classes will be listed on the CTSS. • Registration site at: http://registration.ctss.colostate.edu and advertised through Today@Colorado State.
Professional Development Institute 2009 Discoverer Plus Training • Overview of what training covers. • Creating Workbooks and Worksheets • Report formatting and layout • Sorting and filtering • Conditional formatting • Cross tab reports • Report subtotals and grand totals • Sharing Workbooks with others • Exporting data
Professional Development Institute 2009 Plans for Discoverer Plus • Update from Alan Hill • Delphi • Discoverer Portal w/OID • Discoverer Users Group
Professional Development Institute 2009 More Info on Discoverer Plus • Information Systems maintains a website that contains more information about Discoverer Plus and the ODS. http://applprod.is.colostate.edu:9095/nfslib/work/discoverer.html CTSS Training information: http://www.ctss.colostate.edu/ Or email M.Paquette@ColoState.edu Diane.Zach@ColoState.edu Fran.Campana@ColoState.edu