IBM Cognos Report Studio Advanced (Relational)

  • Course Overview

    This course builds on the 'IBM Cognos Report Studio Essentials (Relational)' course to work on advanced skills in building reports in Report Studio focusing on relational data.

  • Course Duration

    1 day

  • Type of Course

    Instructor-led

  • Level

    Advanced

  • Who is this suitable for?

    Suitable for report authors who want to start using Report Studio to author advanced, professional reports over relational data. It assumes that you have had basic report studio training such as our course 'IBM Cognos BI Report Studio Essentials (Relational)' or experience with producing reports in Report Studio over relational data.

  • Course Content

    Advanced Report Building

    • Convert a list to a crosstab
    • convert one chart to another
    • Defining a static list of prompt values
    • Using database functions
    • Advanced formatting of data
    • Portal pages

    Queries

    • Creating queries manually
    • Create a query from a SQL statement
    • Different ways to join queries

    Distribute Reports Through Bursting

    • Overview of bursting
    • Understanding burst components (burst key, burst recipients, burst label)
    • Bursting based on email address vs CAMID

    Advanced Report Design Enhancements

    • Table of contents
    • Padding, margins and blocks
    • Nesting objects within other objects
    • Let users choose which report objects will appear
    • Include external data in the report
    • Hiding objects
    • Variables types