IBM Cognos Report Studio: Author Professional Reports Advanced (V10.1) SPVC

Description

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 Query Reports Based on Relationships

• Create reports by merging query results
• Create reports by joining queries
• Combine data containers based on relationships from different queries
• Create query containers containing a single data value  

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
• Create a popup window that contains prompts
• 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
• Create a report using an external data file
• Use single data items to summarize report information
• Create a report using external data
• Save reports to server file system

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

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

Introduction to Event Studio (Optional)

• Examine the role of Event Studio in Performance Management
• List the benefits of Event Studio
• Add tasks to an agent
• Run an agent

Build Agents with Event Studio (Optional)

• 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

Aim

With this Training on Demand you will get Experknowledge in professional Reporting with IBM Cognos Report Studio.

Participant requirements

You should have

• Completed IBM Cognos Report Studio: Author Professional Reports Fundamentals (V10.1)
• Knowledge of your business requirements
• Basic knowledge of SQL
• Basic knowledge of XML (recommended)

Participant

This advanced course is intended for Professional Report Authors.