Cognos

 

COGNOS 8.4.1 COURSE-WARE 

Course Duration: 2 Months

Introduction to Performance Management and IBM Cognos 8.4.1 BI

1      Performance Management 

• Defining Performance Management
• BI Business Perspective

2      Monitoring Performance Using Dashboards and Scorecards  

• Dashboards Show Current Information
• Viewing Metrics with Scorecards
• Value of a Balanced Scorecard

3      Introduction to IBM Cognos 8.4.1 Business Intelligence 

• History
• Cognos 8.4.1 User Roles
• Non-Author Roles
• Author Roles
• Cognos Connection and Cognos 8.4.1 Studios
• Cognos Connection
• Query Studio
• Report Studio
• Event Studio
• Metric Studio
• Analysis Studio
• Transformer
• Framework Manager

Accessing and Using IBM Cognos 8.4.1 Business Intelligence

4      Cognos Connection I

• About Cognos Connection
• Customizing Cognos Connection
• Set a Home Page
• Set Preferences
• Run Reports
• Organize Information
• Create a New Folder
• Set the Default View
• Set Properties
• Manage Reports
• Save Report Views
• Schedule Reports
• Create a New Job

5      Cognos Connection II  

• View Output Versions
• Download
• Manage Versions
• Run with Options
• View Historical Information
• View Run History
• View Run History Details

6      IBM Cognos 8.4.1 BI Consumer Modes   : Cognos GO Office !

• Using IBM Cognos 8.4.1 Go! Office
• Connect to Microsoft Office
• Log on to Cognos 8.4.1 Through Microsoft Office
• Import Cognos 8.4.1 Content into an Office Application
• Using BI Analytics in Microsoft Excel
• Publish Microsoft Office Documents in Cognos 8.4.1
• Refresh Cognos 8.4.1 Content in Microsoft Office

Authoring IBM Cognos 8.4.1 Business Intelligence Content

7      Advanced Reporting I   : Report Studio

• Opening Report Studio
• Standard Toolbar
• Style Toolbar
• Insertable Objects
• Explorer Bar
• Work Area
• Properties Pane
• List Report
• Group Data in Reports
• Filtering Reports
• Adding Calculations to Reports
• Adding Summary Lines to Reports
• Setting the Rollup Aggregrate Function
• Basic Report Formatting
• Add a Header to a Report
• Change Font Size in a Report
• Add Background Color to an Object in a Report
• Add a Border to an Object
• Conditional Highlighting
• Prompting
• Cascading Prompt   .
• Adding Formatting to Parameters
• Creating Crosstab Reports
• Creating Chart Reports

8      Advanced Reporting II   : Report Studio

• Create a Drill-Through
• Set Up a Target Report for Drill-Through Access
• Set Up a Source Report for Drill-Through Access
• Master Detail Relationship
• Create a Master Detail Relationship
• Selecting Ancestors
• Modify the Style for Multiple Items
• Query Management
• Query Types
• Specify What Appears when There Is No Data Available
• Dynamic Data Formatting Using Variables
• Bursting Reports
• Advanced Prompting
• HTML Items
• Singleton
• Insert a Singleton Object
• Edit a Query Associated with a Singleton Object

9      Analytics Using Analysis Studio  

• About Analysis Studio
• Defining the Next Business Question
• Understanding Dimensions and Measures
• Create an Analysis
• Open Analysis Studio
• Add Dimensions and Measures
• Drill-Down and Drill-Up  Navigate Down or Up a Level Slice and Dice an Analysis

• Save an Analysis
• Applying Context Filters
• Create and Edit Calculations
• Display Top or Bottom Values
• Applying Zero Suppression
• Applying Complex Filters
• Stacking Items
• Nesting and Stacking Items
• Modify the Layout
• Sorting Data in an Analysis
• Excluding Categories

10   Scorecards and Metrics   : Metric  Designer 

• Introduction to Metric Designer
• Create Metrics
• Metric Types
• Create a Metrics Extract from a Dimensional Source
• Create a Metric Extract from Relational Packages
• Add Multiple Metrics to a Single Scorecard
• Helpful Hints for Working with Metrics
• Ensure Scorecards Have Unique ID Codes
• Choose the Best Time Setting

11   Scorecards and Metrics   : Metric Studio

• Introduction to Metric Studio
• Accessing Metric Studio
• Transfer Metrics
• Transfer Metrics from the Staging Area
• Transfer Metrics from Flat Tables0
• Work with Scorecards
• Create Impacting/Impacted Relationships
• Add Metrics to Scorecards in Metric Studio
• Create Scorecard Strategies
• Develop Watch Lists
• Add Cognos 8.4.1 Reports to Metrics

12 Self-Service Query Authoring: Query Studio

• About Query Studio
• Types of Data
• Data Views
• Create a Query
• Open Query Studio
• Add Query Items
• Move Columns
• Save a Query
• Enhance a Query
• Format a Query
• Modify Advanced Options
• Calculate Data
• Manage a Query
• Open an Existing Query

13    Event Management   : Event Studio 

• Accessing Event Studio
• Navigation in Event Studio
• What Is an Event?
• Business Uses for Event Management
• Creating an Agent
• Specify a Condition
• Test an Agent
• Adding a Task
• Specify the Task Execution Rules
• Preview the Data
• Save an Agent
• Scheduling an Agent
• Maintaining an Agent
• Modify an Event Condition
• Modify a Task
• Delete a Task

Administration of IBM Cognos 8.4.1 Business Intelligence

14   Building the Model: Framework Manager   8.4.1

• What Is a Model?
• Creating a New Model
• Starting a New Project
• Navigating Framework Manager
• Objects that Make Up the Model
• Creating New Objects in Your Model
• Creating Objects to Organize Your Model
• Creating a Namespace
• Creating Folders
• Creating and Editing Query Subjects
• Creating Data Source Query Subjects
• Creating Model Query Subjects
• Creating Relationships
• Relationship Links
• Cardinality
• Creating Filters for Users
• Creating Calculations
• Setting Properties
• Organizing Your Model
• Validating Your Model
• Testing
• Verifying
• The Model Advisor
• Publishing Your Model
• Creating a Package
• Publishing a Package

15   Building the Model:  Cognos Transformer 8.4.1

• Creating Packages and linking with transformer
• Create Dimensions
• Create Measures
• Create Cubes
• Define Data security
• Custom Views
• Create Cube & Publish Package

16   Cognos Connection Management: Cognos Administration & Cognos Configuration

Cognos Configuration 8.4.1

i.    Settings of Cognos Configuration

ii.    How to start & re start cognos

iii.    Details of different parameters

Cognos Administration 8.4.1

i.    Authentication

ii.    Authorization

iii.    Users, Groups, and Roles