Fundamentals of Cognos 10

Cognos Training Course outline

Cognos Architecture

Cognos 10 new features

Cognos Report 8 vs. Cognos 10

Cognos 10 Query Studio

  • Creation Of List Report
  • Converting List to Crosstab
  • Converting List to Chart
  • Interface Formatting
  • Data Formatting
  • Creation of Calculated Column
  • Grouping
  • Sorting
  • Sectioning
  • Creation of Custom Group
  • Report Definition
  • Conditional Formatting
  • Filter
  • Filter grouping
  • Prompts
  • Page brakes
  • Suppress null values
  • Run and Manage Reports
  • Apply template to Query studio report
  • Drill down and drill up
  • How to apply Drill through
Event Studio
  • How to create event
  • How to add task
  • How to run report when event condition satisfied
  • How to run job when event condition satisfied
  • How to send report out put to users through mail
  • How to change task order
  • How to schedule agent
Cognos 10 Report Studio
  • Introduction to Report Studio
    • Report Studi
    • User Interface
    • Creating, Save and Run Reports
    • Report Templates
    • Managing Reports
  • Types of Reports
    • List Reports
    • Crosstab Reports
    • Charts
    • Active form report
  • Formatting a Report
    • Report Layout Guidelines
    • Fonts, Styles, Header, Footer and Borders
    • Insert objects
    • Apply Table Styles
    • Swap Columns and Rows
  • Working with Data
    • Filters, Parameters and Prompts
    • Detail Filter & Summary Filter
    • Context filter
    • Context prompt
    • Slicer
    • Creation of single select prompt
    • Converting single select prompt to multi select prompt
    • Creation of single select cascading prompt
    • Creation of multi select cascading prompt
    • Context filter and context prompt
    • Sorting and Grouping
    • Subtotals and Calculations
    • Working with Queries
  • Working with Reports
    • Conditional Formatting
    • Conditional style
    • Style variables
    • Render variable
    • Drill-through Reports
    • Master-Detail Reports
    • Scheduling Reports
    • Single report deployment
  • Creation Of different type of variable
  • How to apply Page brakes in Report Studio
  • How to apply page brakes using context
  • Creation of Query sets
  • Report Template
    • How to create Report Template
    • How to apply RS Template to Qs report and Rs Report
    • How to convert Report to Template
  • Manage External Data
  • Active Report
    • How to convert report to active report
      • How to use data tab control
      • How to use tab control
      • How to use button bar
      • How to use data button bar
      • How to use toggle button bar
      • How to use toggle data button bar
      • How to use data radio button group
      • How to use data check box group
      • How to use data drop down list
      • How to use data list box
      • How to convert control
      • How to change active report properties
Analysis Studio
  • About Analysis studio
  • Creation Crosstab
  • Nested Crosstab Creation
  • How to create Context filter
  • Add Filter on Rows and columns
  • How to create combined filter
  • How to display excluded item total in report
  • Create Calculated Column
  • How to change Column name
  • Create Custom set
  • Reuse Custom Set
  • Swap rows and columns
  • Create Chart
  • Drill Down and drill up
  • Drill through
  • Top and bottom filter
  • How to add totals and sub totals to crosstab
  • Context filter
  • How to add header to report
  • How to apply page brakes
  • How to apply template
  • Drill down and drill up
  • Drill through
  • How to display cube updated date in header
Cognos 10 Framework Manager
  • Creation of Project
  • Creation of data source connection
    • Data source connection to Database
    • Data source connection to excel
    • Data source connection to Cognos Power play
    • Data source connection to Cognos TM1 Cube
  • Import data From Database
  • Native metadata
  • Creation of Namespace, Folder ,Short cut to the Query subject
  • Joins and cardinality
  • Query subjects
    • Data source query subject
    • Model query subject
    • Stored procedure Query subject
  • Calculation
    • Embedded calculation
    • Standalone calculation
  • Filters
    • Embedded Filters
    • Standalone Filters
  • Query Set
  • Changing Query usage item properties
  • Regular Dimensions
  • Measures Dimensions
  • Scope Defining
  • How to change usage property for Query item
  • Securities
    • Objective level Securities
    • Data Level Securities
    • Package level Securities
  • Model Report
  • Edit Governors
  • Update Query subject
  • Merge Query Subject
  • Creation Of package
  • Creation of nested Package
  • Package versions
  • Publishing package
  • How to publish Package into Desktop
  • How to change Contents in package
  • Report Dependence
  • View Transition history
  • Run script
  • Function Set
  • How to publish more then one cube in one package
  • Copy of Query subject and short cut of query subject
  • Difference between folder and namespace
Cognos 10 Connection
  • Examine Cognos Connection
  • Creation of data Source connection at Cognos connection level
  • Creation Of Report Shortcut
  • Creation of Jobs
  • Scheduling Reports, Report shortcut, Jobs
  • Disabling Schedule
  • Organize content with folders and shortcuts
  • Personalize Cognos Connection
  • How to add portal tab
  • How to add report to portal tab
  • Connecting Report to Another Package
  • Create Users Groups and Users Roles
  • Adding Users to Users Groups
  • Importing and Exporting Reports From one Environment to Another Environment (Development Environment to production Environment )
  • Publishing native metadata into Content store
  • How to copy reports from one persons my folder to another persons my folder
  • Drill through definition
  • How to hide objects in cognos connection
  • How to view hidden object in cognos connection
  • my preferences
  • How to change my preferences
Working with Cognos 10 My Inbox
  • Creation of new tasks
  • Creation of new notifications
  • How to Change Owner
  • How to add comments
  • View comments
    • User comments
    • Audit comments
  • Complete Task
  • How to change Status of a task
  • How to Change Priority of a task
  • Cancel Task s
  • How to archive a Task
My Dashboard
  • About Tool
  • Create New Dashboard
  • Add Report to dashboard
  • Creation of Select Value Filter
  • Creation Of Slider Filter
  • Insert Text into Dashboard
  • How to insert My inbox into Dash Board
  • How to Edit Dashboard Style
  • How to edit source report from Dashboard
  • How to Convert List to crosstab or chart
  • How to change colures for Items in Chart
My Business Insight Advance
  • How to create report using my business insight advance
  • How to apply calculations
    • Round
    • Round up
    • Absolute
    • Round down
    • How to pick first character from item
    • How to pick last character from item
    • How to find difference %
  • How To Format Column
  • How to create calculated columns
  • How to apply Filters
  • How to add context filter
  • How to apply page brake using context
  • How to apply conditional style
  • How to add context filter
  • How use page layer
  • How to add prompt

Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy