IBM Cognos Report Studio Essentials (Relational)

  • Course Overview

    This course will give you the ability to create reports using IBM Cognos Report Studio over relational data.  Learn relational concepts as well as building simple reports and customising them.

  • Course Duration

    2 days

  • Type of Course

    Instructor-led

  • Level

    Intermediate

  • Who is this suitable for?

    Suitable for report authors who want to start using Report Studio to author simple, professional reports over relational data. Also suitable for non-authors who want to gain a basic understanding of Report Studio as well as experienced Report Studio authors who need to plug knowledge gaps and align with best practice. It assumes that you have no prior knowledge of relational concepts or IBM Cognos Report Studio.

  • Course Content

    IBM Cognos Architecture

    • IBM Cognos in an Integrated Financial Performance Management Solution
    • IBM Cognos BI Architecture

    Report Studio Overview

    • Accessing Report Studio
    • Report Studio interface
    • Create a simple report

    Lists

    • Create a simple list
    • Format, sort and group lists
    • Aggregate data
    • List headers and footers

    Filters

    • Different ways to filter reports
    • Filtering on detailed or summary values
    • Static filters (hard-coded) vs variable filters (based on prompts)

    Crosstabs

    • Create a simple crosstab
    • Different crosstab layouts (nesting and stacking)

    Graphs

    • Create a simple chart
    • Different chart types

    Prompt Selections

    • Different prompt types
    • How to create a prompt
    • Defining default prompt selections
    • Sourcing prompt values from a data source
    • Showing prompt selections on the report
    • Cascading Prompts

    Calculations

    • Create derived calculations
    • Create expressions using functions

    Conditional Formatting

    • Highlight exceptional data
    • Highlight data chosen from a prompt selection.

    Drill-Through From One Report to Another

    • Setting up drill through from source to target report
    • Specifying parameters to be passed through

    Layout Enhancements

    • Modifying structures
    • Setting page breaks

    Queries

    • Naming queries
    • Pointing new report objects to existing queries