COURSE CONTENTS FOR Cognos 8.4 - 30 hours
Cognos 8.4 Course Detailed Description

• Cognos Installation Steps, Softwares, Exercises, Training • materials, Certification Dumps will be provided during the

• What is Business Intelligence
• Why is BI Important and where can we use it
• Components of BI
• Business Intelligence Roadmap

• What is Data Warehouse, Why do we need it
• Data Warehouse Architecture and its components
• Define Star Schema - Fact and Dimensions
• Understand OLTP and OLAP Systems

• Examine the different studios in Cognos 8 BI
• Identify the different data sources within the studios
• Highlight key capabilities of Cognos 8 BI
• Understand Cognos Multi Layered architecture

• Installing Cognos 8.4
• Install Database (MS SQL)
• Install Framework Manager
• Install Cognos BI Application
• Setting up the Environment
• Configuring Cognos 8.4
• Setting up Samples in Cognos 8.4
• Uninstalling Cognos 8.4

• Create and Modify a Data Source
• Create Database backups
• Understand Roles, Users and Groups
• Specify Permission Settings

• What is Cognos Connection
• Examine Cognos Connection UI elements – Create a URL,
• Login, Logoff
• Entry Properties: General Properties, Permissions, Report, • Query, Analysis, Job, Agent and Page Properties
• Navigation- Public and Private Folder
• Open reports with Report Name, Go to Links, Run Reports from a

• Run Reports- Prompt Pages, Printing a report and Open
in Excel • View the run history of a report and Historical Reports
• Closing and Creating Quick links to Reports – My Folder
• Shortcut and Browser Bookmark
• Personalize Cognos Connection
• Backups- Export of Cognos, Content Store or select items for

• Restore an exported Backup
• Create and Customize a Page and share a single page with
• Multiple Users

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

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

• Introduction to Report Studio
• Report Studio User Interface
• Creating, Save and Run Reports
• Report Templates
• Managing Reports
• Types of Reports
• List Reports
• Crosstab Reports
• Charts
• Formatting a Report
• Report Layout Guidelines
• Fonts, Styles, Header, Footer and Borders
• Insert objects
• Swap Columns and Rows
• Working with Data
• Filters, Parameters and Prompts
• Sorting and Grouping
• Subtotals and Calculations
• Working with Queries
• Working with Reports
• Managing changes in the Package
• Conditional Formatting
• Drill-through Reports
• Drill-up/Drill-down Reports
• Master-Detail Reports
• Scheduling Reports

• Introduction to Framework Manager
• Framework Manager Basics
• User Interface, Navigation, Objects
• Planning the project and data model. Framework Manager • Workflow
• Naming Conventions for objects in a project
• Designing Project
• Create project
• Importing Metadata from one and more sources
• Exporting Metadata
• 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- Data, Model and Stored
• Procedure Query Subject
• Working with Query Items- Set Usage and Aggregate Property
• 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
• Best Practices – Presentation and Database layers
• Merge Metadata
• Perform Calculations and Filters

• Fundamentals
• What is Cognos Transformer
• Understanding Power Play Data Sources
• Starting and Navigating Transformer
• Importing your source Data
• Creating your Power Cube
• Building the Time Dimension
• Create the Time Dimension Manually
• Building a Transformer Model
• Performance Considerations
• Build Model with AutoDesign
• Modify Property sheets for Dimensions, Levels and
• Categories
• Build Model without AutoDesign
• Create New Dimensions from Source Data
• Creating Exception Dimensions from Source Data
• Specify a Level Label
• Enhancing Your Model
• Creating Sub-Dimensions
• Creating Alternate Drill Paths
• Creating Special Categories
• Creating Calculated Columns
• Creating Multiple Query Power Cubes
• Adding a Query to Existing Model
• View Scope of a Data Source
• Creating a Multiple Query Model
• Currency Conversions and Indentify Measures that use
• Currency Conversions
• Create a Power Cube for Distribution
• Creating Regional Power Cubes
• Adding Cube Password Protection