Section- 1

Introduction to COGNOS

• Impromptu
  • - Basic Fundamentals of Reports
• Transformer
  • - Building Multi-Dimensional Cubes, Measures, Dimensions
• Power Play
  • - Analyze the Data from Cubes
  • - Changing Dimensions, Measures
  • - Drill Down , Slice and Dicing
• Access Manger
  • - Creating Users , User classes

Section- 2

Introduction to COGNOS ReportNet

• ReportNet Features
• COGNOS Connection
• COGNOS Query Studio
• Creating a Report
• Report Types
  • - List Reports
  • - Grouped List Reports
  • - Crosstab Reports
  • - Charts
• Changing the Appearance of Reports
• Working with the Data
  • - Filters
  • - Sorting Data
  • - Grouping Identical Values
  • - Changing the Data Format
  • - Calculations

Section- 3

Report Studio

• The user interface
• Basic Report Structure
• Creating a Report
• Saving a Report
• Running a Report
• Printing a Report
• Types of Reports
• List
• Crosstab
• Charts and Chart Types
• Filtering
  • - Simple Filters
  • - Filtering on Details
  • - Summary Filters
  • - Filtering Groups
  • - Crosstab Filters

• Prompts
  • -Parameters and Prompts
  • -Cascading Prompts
  • -Single Value Prompts with Auto Submit
  • -Multiple Value Prompts
  • -Optional Prompts

Section- 4

Framework Manager

• Projects
• Models
• Namespaces
• Packages
• Query Subjects
  • - Data Source Query Subject
  • - Model Query Subject
  • - Stored Procedure Query Subject
• Projects
• Creating a New Project
• Project Folder
• Templates Folder
• Creating a Data Source
• Importing Metadata
• Relationships
  • - Creating a Relationship
  • - Modifying a Relationship
  • - Creating a Relationship Shortcut
  • - Detecting Relationships

Section- 5

• Preparing a Model for Reporting
• Query Subjects
• - Create a Query Subject
  • - Modify a Data Source Query Subject
  • - Modify a Model Query Subject
  • - Modify a Stored Procedure Query Subject
• Testing a Query Subject
• Create a Folder
• Create a Query Item Folder
• Modify Properties
  • - Merging Metadata to Create a New Query Subject
  • - Creating Calculations
  • - Creating and Applying Filters
  • - Creating Prompts
  • - Creating a Parameter Map
  • - Creating and Using a Macro
  • - Multilingual Support

Each Day includes Theory and Lab practice

• Examples based on theory
• Exercises

What you’ll learn

• Basic fundamentals of Reports, Creating Reports, Report Studio, Framework Manager, Creating Query subject.