COGNOS Online Training

cognos online training

  • What is Cognos ?

    Cognos is a developer of business intelligence software. They are one of the largest suppliers of business intelligence tools, globally, and the name is recognized as a leader in their field of BI reporting.

    Cognos was found in the late ’60s in Ontario but is now part of the IBM group, as they were acquired by IBM in 2008 and are now part of their business analytic division.

    While Cognos provide a whole suite of business intelligence reporting software and tools, their name has become synonymous with OLAP, (Online Analytical Processing).

    BI tools are used in many organizations and for various tasks including

    To implement a Cognos solution, a consultant would most likely be assigned to your organization to undertake an analysis of your current operational systems and to determine the most effective implementation of an intelligence analysis system.

  • COGNOS Business Intelligence Training

    Introduction to data warehousing.

    Introduction to Cognos online training

    Introduction to the Reporting Application

    Describe IBM Cognos BI Training components

    IBM Cognos Report Studio: Author Professional Reports Fundamentals

    Examine Report Studio and its interface

    Explore different report types

    Create a simple, sorted, and formatted report

    Explore how data items are added to queries

    Create List Reports

    Format, group, and sort list reports

    Describe options for aggregating data

    Create a multi-fact query

    Create a report with repeated data

    Focus Reports Using Filters

    Create filters to narrow the focus of reports

    Examine detail and summary filters

    Determine when to apply filters on aggregate data

    Create Crosstab Reports

    Format and sort crosstab reports

    Convert a list to a crosstab

    Create complex crosstabs using drag and drop functionality

    Create crosstabs using unrelated data items

    Present Data Graphically

    Create charts containing peer and nested items

    Add context to charts

    Create and reuse custom chart palettes

    Present key data in a single dashboard report

    Focus Reports Using Prompts

    Identify various prompt types

    Use parameters and prompts to focus data

    Search for prompt items

    Customize prompts to facilitate users’ choices

    Navigate between pages

    Display users’ prompt selections in the report

    Extend Reports Using Calculations

    Create calculations based on data in the data source

    Add run-time information to the reports

    Create expressions using functions

    Use Additional Report Building Techniques

    Reuse objects within the same report

    Share layout components among separate reports

    Discuss report templates

    Add pages to a report

    Choose options to handle reports with no available data

    Customize Reports with Conditional Formatting

    Create multi-lingual reports

    Highlight exceptional data

    Show and hide data

    conditionally render objects in reports

    Drill-Through From One Report to Another

    Let users navigate from a specific report to a target report

    Pass parameter values to filter the data in drill-through targets

    Drill-through Definitions

    Parameter-driven drill through

    Steps to enable drill-through access for a package

    Drill Through Assistant

    Enhance Report Layout

    Force page breaks in reports

    Modify existing report structures

    Apply horizontal formatting

    Specify print options for PDF reports

    Combine data containers displaying data from different queries

    Format data and report objects

    IBM Cognos Report Studio: Author Professional Reports Advanced

    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

    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

    Examine the Report Specification

    Examine the report specification structure

    Save and edit reports locally

    Discuss considerations for modifying a report specification

    IBM Cognos Report Studio: Author Active Reports

    Introduction to IBM Cognos Active Reports

    Discuss the value of active reports

    Examine an active report and its controls

    Convert an existing report to an active report

    Debug and save an active report

    Explore interactive properties

    Use Filter and Select in Active Reports

    Distinguish between filter and select

    Examine decks and cards

    Explore properties to use in active reports

    Examine master-detail relationships and decks

    Use Advanced Features with Active Reports

    Drill through on an active report

    Drill up an down on an active report

    Create cascading prompts in an active report

    Query studio:

    Types of reports

    Query studio templates

    User interface

    Operation on list report

    Data formatting

    Expand and collapse group

    Custom groups

    Filters and calculations

    Conditional formatting


    Analysis studio:

    Introduction to analysis studio

    Types of analysis

    Rows columns and context

    Suppress zeros and nulls

    Filters and calculations

    Top and bottom rows


    Drill up and drill down

    Convert to chart

    Replacing columns and rows

    Open in report studio

    Event studio:

    Benefits of event studio

    Process flow

    Specify event condition


    Task execution rules


    Scheduling an agent

    Framework Manager

    IBM Cognos Framework Manager: Design Metadata Models

    Create a Baseline Project

    Examine the IBM Cognos BI and Framework Manager workflow processes

    Define a project and its structure

    Describe the Framework Manager environment

    Create a baseline project

    Enhance the model with additional metadata

    Prepare Reusable Metadata

    Verify relationships and query item properties

    Ensure efficient filters by configuring prompt properties

    Calculations and Filters

    Use calculations to create commonly-needed query items for authors

    Use static filters to reduce the data returned

    Use macros and parameters in calculations and filters to dynamically control the data


    Specify Determinants

    Use determinants to specify multiple levels of granularity and prevent double-counting

    Create the Presentation View

    Identify the dimensions associated with a fact table

    Identify conformed vs. non-conformed dimensions

    Create star schema groupings to provide authors with logical groupings of query subjects

    Work with Different Query Subject Types

    Identify key differences and recommendations for using data source, model, and stored

    Procedure query subjects

    Identify the effects on generated SQL when modifying query subjects, SQL settings and


    Set Security in Framework Manager

    Examine the IBM Cognos BI security environment

    Restrict access to packages

    Create and apply security filters

    Restrict access to objects in the model

    Create Analysis Objects

    Apply dimensional information to relational Metadata to enable OLAP-style queries

    Sort members for presentation and predictability

    Advanced Generated SQL Concepts and Complex Queries

    Governors that affect SQL generation

    Stitch query SQL

    Conformed and non-conformed dimensions in generated SQL

    Multi-fact/multi-grain stitch query SQL

    Variances in Report Studio generated SQL

    Dimensionally modeled relational SQL generation

    Cross join SQL

    Various results sets for multi-fact queries

    Use Advanced Parameterization Techniques in Framework Manger

    Identify session and model parameters

    Leverage session, model, and custom parameters

    Create prompt macros

    Leverage macro functions associated with security

    Model Maintenance and Extensibility

    Perform basic maintenance and management on a model

    Remap metadata to another source

    Import and link a second data source

    Run scripts to automate or update a model

    View lineage

    Create a model report

    Optimize and Tune Framework Manager Models

    Identify and implement techniques to optimize and tune your Framework Manager


    Work in a Multi-Modeler Environment

    Implement repository control

    Segment and link a project

    Branch a project and merge results

    Manage OLAP Data Sources

    Connect to an OLAP data source (cube) in a Framework Manager project

    Publish an OLAP model

    Publish a model with multiple OLAP data sources

    Publish a model with an OLAP data source and a relational data source

    Manage Framework Manager Packages

    Specify package languages and function sets

    Control model versioning

    Nest packages

    IBM Cognos BI Administration

    Describe IBM Cognos architecture at a high level

    Define IBM Cognos groups and roles

    Explain how to extend IBM Cognos BI

    Introduction to IBM Cognos BI Administration

    Describe the role of the Administrator in relation to the IBM Cognos BI administration

    Workflow process.

    Describe the role of IBM Cognos Administration and IBM Cognos Configuration user

    interface components

    Identify IBM Cognos BI Architecture

    Identify features of the IBM Cognos BI architecture

    Identify an example of Cognos BI request processing

    Performance planning and installation options and configurations

    Perform IBM Cognos BI on a single machine

    Secure the IBM Cognos BI Environment

    Identify the IBM Cognos BI security model

    Define authentication and authorization in IBM Cognos BI.

    Identify security policies

    Secure administrative capabilities (access to functionality)

    Specify security settings after installation.

    Implement security in IBM Cognos Framework Manager and IBM Cognos Transformer

    Administer the IBM Cognos BI Server Environment

    Overview of administrative tasks that can be performed in IBM Cognos Administration

    Monitor system metrics

    Manage dispatchers and services

    Tune server performance

    Identify issues while troubleshooting the server environment

    Formulate the IBM Cognos BI backup strategy

    Manage Run Activities

    Manage current, past, and upcoming run activities

    Manage schedules

    Manage Content in IBM Cognos Administration

    Add and manage a data source

    Distribute data and create a distribution list and contacts

    Deploy IBM Cognos BI content

    Maintain the IBM Cognos BI content store

    Customize the appearance of IBM Cognos BI

  • Cognos  Video

  • Cognos prerequisites


Fill up quick inquiry form to get more details on Cognos online training