Advanced Reporting on the Web (Report Studio) with IBM Cognos 10

This Advanced Reporting on the Web (Report Studio) with IBM Cognos 10 training class provides advanced techniques with IBM Cognos' Report Studio.Topics include the Query Explorer, bursting reports, advanced prompting, drill-through definitions, active reports, using external data, working with dimensional data and more.The course format includes lecture, instructor-led exercises and independent workshops.

This course is for report authors and developers who will create and maintain complex reports in Report Studio.

Location

Public Classes: Delivered live online via WebEx and guaranteed to run . Join from anywhere!

Private Classes: Delivered at your offices , or any other location of your choice.

Goals
  1. Create advanced queries including joins, unions and sub queries using the Query Explorer.
  2. Create prompts with static values.
  3. Create advanced prompts for use in sorting and conditional blocks.
  4. Apply bursting to reports.
  5. Import external data in Report Studio.
  6. Create basic active reports with data check box groups, data tab controls and data drop down lists.
  7. Create a dashboard with drill-through capabilities and a render variable.
  8. Create a table of contents.
  9. Apply dimensional reporting techniques with cubes.
Outline
  1. Review of IBM Cognos 10 and Report Studio
    1. Review of IBM Cognos 10
    2. Review of Report Studio Reporting Techniques
  2. Introduction to the Query Explorer
    1. Query Components
    2. Build and modify queries from the Query Explorer
    3. Create union and join queries
    4. Create queries with SQL
    5. Create child queries
  3. Introduction to Bursting
    1. Definitions
    2. Create a bursted report
  4. Advanced Prompting
    1. Review of prompts
    2. Prompts with static values
    3. Prompts that perform sorting
    4. Conditional formatting with prompts
  5. Introduction to Active Reports
    1. Understand Active Reports
    2. Convertreports to Active Reports
    3. Create Active Reports with Controls
  6. Use External Data
    1. Introduction to Using External Data
    2. Link External Data to a Report
    3. Link External Data to a Query Subject
  7. Advanced Reporting
    1. Complex Report Examples
      1. Advanced Drill Through
      2. Complex calculations
      3. Table of Contents
      4. Dynamic time periods
  8. Working with Dimensional Models
    1. MDX and Unique Member Names
    2. Work with Context Filters and Member Sets
    3. Work with Dimensional functions
    4. Period to Date Calculations
    5. Tree Prompts
  9. Introduction to Event Studio
    1. Examine Event Studio
    2. Create an Agent and Task
  10. HTML Items (Appendix)
    1. Basic HTML in Report Studio
  11. Import and Export XML Reports (Appendix)
    1. View and Understand the Report Specification
    2. Import XML Report Specifications
    3. Export XML Report Specifications
    4. Create Templates
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Cognos class:

  • Experience with Report Studio.

Training for your Team

Length: 2 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

Excellent trainer! She understands the material and how to teach it. Very impressed.
Ben Peacock
Academic Travel Abroad
The most productive training course that I ever had. I was able to go from knowing very little to being productive in three days.
Rob Pesce
NCA Group, Inc.
I'd always felt intimidated by Photoshop, but the introductory course gave me the confidence I need to edit and produce images that will significantly improve the quality of my work.
Carole Manny
Food and Drug Administration
Webucator has the understanding of how to deliver content in a way to make learning long lasting. Way-To-Go!
Ronnie Huffman
50 OSS

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

63,175

Students who have taken Instructor-led Training

11,876

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.29

Students rated our trainers 9.29 out of 10 based on 29,679 reviews

Contact Us or call 1-877-932-8228