Cognos Training Certification

Cognos Online Training

Overview of Cognos 8 BI

• Introduce Cognos 8 BI
• Describe IBM Cognos 8 BI components
• Describe IBM Cognos 8 architecture at a high level

Cognos 8 Installation and Configuration

• Components used by Cognos 8
• Server Components
• Modeling Components
• Installing Cognos 8
• Setting up the Environment
• Configuring Cognos 8
• Setting up Samples
• Uninstalling Cognos 8

Cognos 8 BI Admin

• Configuration of third party security at Cognos level
• Define IBM Cognos 8 groups and roles
• Assign the Roles to Users or Groups

Cognos 8 Framework Manager

• Introduction to Framework Manager
• Framework Manager Basics
• User Interface, Navigation, Objects
• Planning the project and data model
• Naming Conventions for objects in a project
• Designing Project
• Create project
• Importing Metadata
• Exporting Metadata
• Multi-user Modeling
• Segmenting and Linking
• 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 – Determinants, Regular Dimensions, Measure Dimensions, Scope Relationship-Dimensional Modeling of Relational Data Sources

Cognos 8 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
• Subtotals and Calculations
• Run and Manage Reports
• Drill Through reports

Cognos 8 Report Studio

• Introduction to Report Studio
• Report Studio User Interface
• Creating, Save and Run Reports
• Report Templates
• Managing Reports
• Formatting a Report
• Report Layout Guidelines
• Fonts, Styles, Header, Footer and Borders
• Insert objects
• Apply Table Styles
• Swap Columns and Rows
• Create Additional Advanced Reports
• create a report that displays summarized data before
• detailed data
• highlight alternate rows in a list report
• use single data items to summarize report information
• save reports to server file system
• Drill-through Reports
• Drill-up/Drill-down Reports
• Master-Detail Reports
• Scheduling Reports
• Working with Data
• Filters, Parameters and Prompts
• Sorting and Grouping
• Subtotals and Calculations
• Working with Queries
• Create Query Models
• build query models and then connect them to the report layout
• add filters and prompts to a report using the query model
• edit an SQL statement to author custom queries
• Create Advanced Dynamic Reports
• filter reports on session parameter values
• navigate a briefing book using a table of contents
• create dynamic headers and title that reflect report data
• let users navigate to specific locations in reports
• create a customer invoice report

Cognos PowerPlay Transformer

• Transformer Fundamentals
• Discuss the basics of OLAP analysis
• Review Transformer capabilities and its role in IBM Cognos 8 BI
• Discuss Transformer components
• Define categories and members
• Transformer Development Process
• Data Sources in Transformer
• Building a Model
• Define Dimensions, Levels and Measures
• Time Dimensions, Relative Time

Types of Security

• Data Level
• Objective Level
• Package level
• SQL Generated by Cognos 8
• Understanding Dimensional Queries
• Resolving Ambiguously Identified Dimensions and Facts
• Resolving Queries that should not have been split
• Resolving Queries that are split in the wrong place

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
• Creation of Portal pages
• Design Effective Prompts
• control report displays using prompts
• specify conditional formatting values using prompts
• create a report that formats based on prompts selection
• create a sorted and filtered report based on prompt selection
• Currency Conversion
• Create Power Cube
• Advanced Dimensional Modeling
• Applying Security
• Drill Through
• Optimizing PowerCubes
• Deployment of PowerCubes to the Cognos Connection

Cognos 8 Analysis Studio

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