1 / 20

OSCA Reporting -- Sam II

OSCA Reporting -- Sam II. Using Cognos Impromptu. What is Cognos Impromptu?. Cognos - A company that has a variety of business intelligence software. Impromptu - Reporting Tool for querying data and creating reports. Impromtu ‘Parts’. Catalogs SamII FN SamII HR

margie
Download Presentation

OSCA Reporting -- Sam II

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. OSCA Reporting -- Sam II Using Cognos Impromptu

  2. What is Cognos Impromptu? • Cognos - A company that has a variety of business intelligence software. • Impromptu - Reporting Tool for querying data and creating reports

  3. Impromtu ‘Parts’ • Catalogs • SamII FN • SamII HR • Catalogs for other OSCA Systems • Reports • User Developed • Standard Reports • Security

  4. An Impromtu Catalog • Connects to the Database • Accesses Tables and Columns • Creates Joins Between the Tables • Organizes Tables and Columns Into Folders • Can Contain Calculations, Conditions, and Prompts

  5. FN Catalog - Joins

  6. HR Catalog - Joins

  7. Catalog Security - Logon to SAM II • Access Manager • User Classes • Users • Common logon

  8. Financial Catalog - Folders

  9. HR Catalog - Folders

  10. Building a Report • Selecting Data Items • Filtering • Sorting • Grouping • Formulas • Totals • Prompts

  11. Selecting Data Items

  12. Formulas

  13. Filtering

  14. Grouping

  15. Sorting

  16. Totals

  17. Prompts Add to Filter Statement And PO Date between ?Begin Date? And ?End Date?

  18. Questions

More Related