Cognos Training : Fundamentals of Cognos 10

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

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

Analysis Studio

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

My Dashboard

My Business Insight Advance