Cognos 8 Report Studio Advanced Training Class

Cognos 8 Report Studio Advanced Training Seminar

Course Description:

Course Objectives:

• Retrieve information using Query Explorer
• Create sophisticated prompts
• Modify reports and prompt pages using HTML
• Explain the concepts of scheduling by a trigger
• Render columns and report objects using conditional logic
• Apply Event Studio

Prerequisites:

• Cognos?? 8.3 Report Studio Introduction or equivalent knowledge

Course Topics:

I. Query Explorer

• Creating a query before the report
• Join object
• Cardinality
• Union object
• Intersect and except
• Subquery queries
• User written SQL for a report
• Changing user written SQL
• Changing Report Studio generated SQL
• Joining multiple queries

II. Additional Prompt Topics

• Static value prompt
• Value prompt with radio buttons
• Using parameters in the display
• Default prompt value
• Dynamic report columns
• Dynamic sort order
• Query macro
• Dynamic filtering

III. Event Studio

• Create detailed agent
• Event properties and options
• Event Studio options
• Summary agent
• Task execution rules

IV. Additional Topics

• Suppress initial prompt
• Summary in header
• Bookmarks
• Table of contents (8.3)
• Drill through to self
• Dashboard
• XML
• Scheduling by trigger
• HTML
• Modifying prompt pages with HTML and JavaScript

V. Conditional Processing and Bursting

• Conditional rendering
• Conditional blocks with Boolean variables
• Conditional blocks with string variables
• Bursting