1 / 21

Pennsylvania Banner Users Group 2008 Fall Conference

Pennsylvania Banner Users Group 2008 Fall Conference. Finance Reporting from the ODS using Cognos. General Announcements:. Please turn off all cell phones/pagers If you must leave the session early, please do so as discreetly as possible Please avoid side conversations during the session

garima
Download Presentation

Pennsylvania Banner Users Group 2008 Fall Conference

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. Pennsylvania Banner Users Group 2008 Fall Conference Finance Reporting from the ODS using Cognos

  2. General Announcements: • Please turn off all cell phones/pagers • If you must leave the session early, please do so as discreetly as possible • Please avoid side conversations during the session • Questions will be answered ….. Thank you for your cooperation

  3. Session Outline • Why Cognos 8? • Who is the customer and what information is needed? • Now, a word from our customer… • Content • Delivery • User feedback • Spotlight >> Multidimensional cubes << • Q&A

  4. Dickinson College • Private, four year, undergraduate, liberal arts College located in Carlisle, PA • 2,388 students (Fall 2008) • $350M Endowment (FY08)

  5. Why Cognos 8 for Financial Reporting? The need for fact-based decisions based on enterprise-wide information Timely and consistent data Features Robust and customizable User friendly Fit into College-wide ERP and BI implementation strategy

  6. Why Cognos 8 for Financial Reporting? (cont) Provides for a single version of the metadata Relatively seamless integration between queries, reports, charts, powercubes, and scorecards User-oriented interface

  7. Who is the customer and what information is needed? VP, Treasurer of College Treasurer’s report Monthly Auxiliary P&L’s Financial Statements Associate VP and Treasurer Treasurer’s report Financial Statements Director of Planning and Budget Treasurer’s report Weekly Auxiliary P&L’s Budget preparation reports Multi-dimensional cube reports Financial Statements

  8. Who is the customer and what information is needed? Director of Int’l and Grant Accounting T-reports Multi-dimensional cube reports Financial Statements Financial Controller, Assistant Controller T-reports Financial Statements Weekly Ad-hoc requests Bursar and AR office staff FOAPAL distribution reports Account activity by detail code/term Accounts with holds Cash/deposit reconciliations Other audit/reconciliation reports

  9. Cognos 8 BI Interface Numerous Reporting Capabilities, Including: 1) Financial Statements; 2) Auxiliary P&L’s; 3) Self Service Reports; 4) Legacy System Reports; and 5) Treasurer’s Reports

  10. Treasurer’s Report Summary High level report that enables the Treasurer and Directors to see a “snapshot” of the College’s operating budget position at any point in time

  11. Balance Sheet The College’s official, audited Balance Sheet is 100% automated in Cognos 8

  12. Operating Statement of Activities The Operating Statement of Activities is also 100% automated in Cognos 8, and the College’s official document

  13. Multi-dimensional Cubes Easy click, drag, and drop functionality for end users Virtually unlimited fiscal years worth of data can be analyzed quickly and easily Fund groupings can be conventional U, T, P or customized for your particular needs FOAPAL is structured in hierarchal format

  14. Multi-dimensional cubes (cont) Zero and/or blank suppression option Multiple measures across multiple timeframes can be reported and analyzed easily Customized calculations

  15. Multi-dimensional cubes (cont) Report developed by Director of Planning and Budget

  16. Multi-dimensional cubes (cont) Report filters can be displayed in output, if desired Program Expenses Year-over-Year analysis of FY Budget and FYTD Actuals All departments with program expenses

  17. Multi-dimensional cubes (cont) Data can be viewed in a conventional crosstab/spreadsheet format, or in a variety of charts/graphs.

  18. Multi-dimensional cubes (cont)

  19. Multi-dimensional cubes (cont) Drop-down menus allow for quick and easy changes of data sets

  20. Multi-dimensional cubes (cont) FOAPAL elements can be nested, grouped, and sorted. Year-over-Year comparisons created quickly and effortlessly by END USERS!

  21. Open to the Floor • Questions • Comments

More Related