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