Cognos Resources

Cognos is used to create and distribute custom reports of Banner and other data. 

Cognos Open Labs for report writers are held on the first and third Thursday of the month
in 103 Stewart Hall, from 9:00 am to 4:00 pm. 



Resources

• Cognos Online Report Inventory (Link to web site)
• Cognos - Consumer User Guide (PDF)
• ODS - How to Locate a Field in Banner (PDF)
• ODS Change Request Form (Word Document)
• ODS Metadata v. 3.1 (Link to web site)

Karate Belt

"Master the Art of Business Intelligence"

 

White Belt
	Report Studio (PDF)
Yellow Belt
Series I	Inserting Code and Description in Prompt (PDF) Inserting Code and Description in Report (PDF) Prompt Value in Title (PDF)
Series II	Cascading Prompt (PDF) Building Drill-Through Reports (PDF)
Series III	Inserting Charts (PDF) Multiple Queries (PDF)
Orange Belt
Series I	Create a Portlet (PDF) Limit Number of Records Returned (PDF)
Series II	Condensed List Report (PDF) Using the List of Values (PDF) Change Sort Order (PDF)
Series III	Headers and Footers (PDF) Crosstab Reports (PDF) Conditional Formatting (PDF)
Blue Belt
Series I	Street Address and E-mail Slot (PDF) Page Breaks (PDF)
Series II	Return Part of a Field (PDF) Advanced Sorting Techniques (PDF)
Series III	One-Click Dynamic Column Sorting (PDF) Using Banner and Metadata to Locate Query Items (PDF)
Green Belt
Series I	Nesting Chart and Crosstab Data (PDF) Customize and Reuse Color Palettes (PDF)
Series II	Add Custom Properties to Charts (PDF) Prompt Types (PDF)
Series III	List vs. Crosstabs (PDF) Online Report Inventory (PDF)
Purple Belt
Series I	Functions (PDF) Function Definitions Table (PDF)
Series II	User Defined Prompts and Maps (PDF)
Series III	Best Practices PowerPoint (PDF) Adding Kent State Portlet (PDF) List of Values (PDF) Scheduling (PDF)
Brown Belt
Series I	Joins (PDF) Reference Queries (PDF)
Series II	Personalized Letters (PDF) Page Sets (PDF)
Series III	Creating Slots (PDF)
Black Belt
Series I	TBD
Series II	TBD
Series III	TBD