Courses
Course : Dataware Housing
Sub Course : Cognos
Content :

User Interfaces

o Cognos Connection
o Query Studio, Report Studio, Analysis Studio, Event Studio
o Frame work Manager

Cognos 8 Servers

o Content Manager,,,
o Dispatcher
o Content Store

Technology

o Java Application Server
o C++ components

Communications

o Cognos BI Bus API Protocol
o Messaging and Dispatching

Log Message Processing

o Sending log information in a Distributed Installation
o Database connection Management
o Ports
o Request Flow Processing

Work Flow

o Planning for Implementation
o Implementing Cognos 8
o Administering Cognos 8
o Creating Models and Packages
o Authoring Reports

Frame Work Manager

Designing a Project

o Naming conventions for objects in a project
o Connecting to Data Sources
o Create a Data Source Connection
o Importing Meta Data
o Preparing Meta Data for using Reports
o Verifying Relationships
o Working with Query Subjects
o Modifying the properties of Query items
+ Format Query items
+ Define a prompt control
+ Modifying how query items are aggregated

Adding business rules

o Creating calculations and Filters
o Using prompt values to filter data
o Create a business view of the model
o Use short cuts
o Create a folder or name space
o Create a query item folders
o Dimension models
o Specify dimension information
o Create the package
o Publishing a package
o Verify a model and Set Governors

Query Studio-Advantages

o Creating a Report
o Report types
o Lost Reports
o Grouped List Reports
o Cross tab reports
o Charts

Changing the Appearance of the Reports

o Applying Filters
o Shorting Data
o Custom groups
o Group identical values
o Calculations
o Producing report in various formats

Report Studio

o Working in Cognos report studio
o The user interface
o Basic Report Structure
o Working with Objects
o Creating and Managing Reports
o Types of Reports
o List Reports
o Cross tab Report
o Charts and Repeaters
o Formatting a Report
o Swapping rows and columns
o Working with Data
o Filter data
o Sort data
o Create Sections
o Adding Prompts
o Working with Queries
o Drilling through Cognos Reports
o Report Studio Objects and Properties
o A work shop on Project Manager
o Query Studio and Report Studio

Analysis Studio

o Analysis Studio
o Creating Basic Analysis
o Working with items in the Cross Tab
o Focusing your Analysis
o Limiting the items in your Analysis
o Using calculations
o Sharing Results

Sub Courses
Informatica
Business objects
Ab Initio
Datastage
Cognos
Data Stage
Dwh