IBM Cognos 8 BI Report Studio: Author Professional Reports Advanced (V8.4) SPVC

Examine the Report Specification

• examine the report specification structure
• save and edit reports locally
• discuss considerations for modifying a report specification
• discuss adding custom toolbox objects and custom template options

Create Query Models

• build query models and then connect them to the report layout
• add filters and prompts to a report using the query model
• edit an SQL statement to author custom queries

Create Reports Based on Query Relationships

• create reports by merging query results
• create reports by joining queries
• combine data containers based on relationships from different queries

Distribute Reports Through Bursting

• distribute reports using bursting
• create burst keys
• identify report recipients and data items using burst tables
• distribute reports using email and IBM Cognos Connection

Create Advanced Dynamic Reports

• filter reports on session parameter values
• navigate a briefing book using a table of contents
• create dynamic headers and title that reflect report data
• let users navigate to specific locations in reports
• create a customer invoice report

Design Effective Prompts

• control report displays using prompts
• specify conditional formatting values using prompts
• create a report that formats based on prompts selection
• create a sorted and filtered report based on prompt selection

Enhance User Interaction with HTML

• create tooltips that clarify report data
• send emails using links in a report

Create Additional Advanced Reports

• create a report that displays summarized data before detailed data
• highlight alternate rows in a list report
• use single data items to summarize report information
• save reports to server file system

End-to-End Workshop

• various managers have requested a number of reports to answer business questions pertaining to their areas of interest
• you have been provided with the requirements for each report
• you must create an deliver these reports by the end of the day

Optional - Introduction to Event Studio

• examine the role of Event Studio in Performance Management
• list the benefits of Event Studio
• add tasks to an agent
• run an agent

Optional - Build Agents with Event Studio

• create agents
• use calculations and parameters in Event Studio
• add tasks (email, report, database update, agent)
• manage task execution rules
• test an event through its lifecycle
• schedule an agent