DW COGNOS Contents

COGNOS 8 BI

Overview of Cognos 8 BI

* Introduce Cognos 8 BI
* Examine the different studios in Cognos 8 BI
* Identify the different data sources within the studios

Cognos 8 Installation and Configuration

* Components used by Cognos 8

* Server Components
* Modeling Components

* Installing Cognos 8
* Uninstalling Cognos 8

Cognos 8 BI Architecture and Planning

* Architecture

* Multi-tire architecture
* Communications
* Workflow
* Security

Cognos 8 Connection

* Examine Cognos Connection
* Run and view reports
* View the run history of a report
* Organize content with folders and shortcuts
* Customize report outputs by using report views
* Schedule single and multiple reports
* Personalize Cognos Connection

Query Studio

* Introduction to Query Studio
* Create Reports (List, Grouped List, Crosstab, Charts)
* Changing the Appearance of Reports (Format)
* Sorting and Grouping
* Filters and Prompts
* Calculations
* Run and Manage Reports
* Drill Through reports

Analysis Studio

* Introduction to Analysis Studio
* Creating a Basic Analysis
* Working with data in Crosstab
* Exploring Data
* Limiting Data
* Calculating Data

Report Studio

* Introduction to Report Studio

* Report Studio User Interface
* Creating, Save and Run Reports
* Report Templates
* Managing Reports

* Types of Reports

* List
* Cross tab
* Charts
* Maps

* Formatting a Report

* Report Layout Guidelines
* Fonts, Styles, Header, Footer and Borders
* Insert objects
* Apply Table Styles
* Swap Columns and Rows
* Create and Modify Classes

* Working with Data

* Filters, Parameters and Prompts
* Sorting and Grouping
* Calculations
* Working with Queries

* Working with Reports

* Managing changes in the Package
* Report Bursting
* Conditional Formatting
* Drill-through Reports
* Drill-up/Drill-down Reports
* Master-Detail Reports
* Scheduling Reports

Framework Manage (Metadat Modeling)

* Introduction to Framework Manager

* Framework Manager Basics
* User Interface, Navigation, Objects

* Designing Project

* Create project
* Importing Metadata
* Exporting Metadata
* Create Model Documentation

* Data Sources

* Working with Data Source Connections
* Create and Modify Data Sources
* Improve Performance by setting Query Processing Type

* Preparing Relational Metadata for use in Reports

* Verifying Relationships
* Working with Dimensions
* Working with Query Subjects
* Working with Query Items
* Supporting Multilingual Metadata
* Adding Business Rules
* Organizing the Model

* Making Metadata Available to Report Authors

* Verify Model
* Set Governors
* Improving Performance
* Create or Modify Package
* Controlling access to Metadata
* Explore Package
* Publish Package

* Guideline for Modeling Metadata

* Scenarios
* New Objects - Regular Dimensions, Measure Dimensions, Scope Relationship
* Dimensional Modeling of Relational Data Sources

Event Studio

* Introduction to Event Studio
* Events

* Event Instance
* Event List
* Event Key
* Task Execution Rules

* Agents
* Tasks
* Creating an agent
* Working with Agents in Cognos Connection