Cognos Training

Cognos Training Overview

The Best Cognos Software Training Institute

Cognos software training creates extra grasp over business intelligence to financial performance and strategy management and it is considered as an extra managerial skill for business management. In India KBS Training Institute offers best quality training for Cognos both via online and regular classroom method. While mostly regular students prefer to attend classroom coaching, on job professionals often find preferring Cognos Online Training as they can attend the classes from home and at their flexi time. KBS Training Institute provides best quality training for their best teaching faculties as well as for their intense research on the latest industry trend which makes their students groomed and trained as per the industry requirement.KBS Training Institute provides quality placement assistance for their students.

Cognos Training Course Content

Cognos TM1 Architecture

INTRODUCTION TO IBM COGNOS TM1

TM1 Components

• Tm1 architect
• Tm1 perspectives
• Tm1 turbo integrator
• Tm1 Cube Viewer
• Tm1 Subset Editor

Create Elements

• Types of Elements
• Simple
• String
• Consolidated
• Creation of elements
• Editing Elements
• Adding alias attributes to elements
• Using alias attribute in Cube viewer

Creation of Dimension

• Creation of dimension manually
• Creation of dimension using TI process
• Creation of dimension using Dimension worksheet
• Creating dimension using CSV as Data source
• Creating dimension using Database as Data source
• Creating dimension using subset as data source
• Creating more then one dimension from one data source
• Creating Alias attributes using Alias process
• Adding alias attribute for existing dimension using TI process

Creation of Cube manually

Creating of Cube using TI process

Loading data into Cube

Updating data in Cube

Creation of Subset

• Creation Of Subset
• How to create public subset
• How to create private subset
• How to create default subset
• How to create dynamic subset
• Use Subset in Cube

Creation of Cube View

• Private View
• Public View
• Default View

Creation Of filter

• Filter by Level
• Filter by Wildcard
• Filter by attribute
• Data Filter Creation

Working with Sandboxes

• Creation of sandboxes
• Deleting sandboxes
• Commit Sandboxes
• Reset data

Work with Spreadsheets

• Creation of Slice
• Creation of snapshot
• Creation of Active from
• Active from vs snapshot
• Snapshot vs slice

Working with Worksheet Slice and active form

• Adding Action Buttons in worksheet

In Spreadsheet Browser

• How to Create In Spreadsheet Browser
• How to swap row and columns

Worksheet Functions

• DBR
• DBRW
• SUBNM
• VIEW

Create Slice report Using Function

Pick List

• How to create Static Pick List
• How to create Subset Pick List
• How to create Dimension Pick List

WORKSHEET CONTROLS

• Data Validation

FORMAT AND PRINT RESULTS

• How to print report in single work book
• How to print report in multiple work books

Drill Through

• Drill through to cube view
• Drill through to Data Source(using ODBC)

Adding Business Rules

Writing business Rules

Controlling calculations

Adding business logic to rules

Data Spreading and hold values

MANAGE THE SERVER

• Broadcast Messages to Clients
• Disconnect Clients from the TM1 Server
• Shut Down Remote TM1 Servers

REPLICATE AND SYNCHRONIZE SERVERS

• Replicate Cubes: Overview
• Replicate Cubes: Advantages
• Remove Replications
• Synchronization
• Schedule synchronization
• Delete Replicate

About Log

• Admin Server Log
• Transaction Log
• Server Message Log
• Audit Log

Deleting data in cube

Tm1 Security

• Manually adding users to Server
• Adding users to user groups using TI process
• Creation of groups
• Apply Security to cubes
• Apply security to Dimensions
• Apply security to Elements
• Cell level security

Integrate with IBM Cognos 10 BI

• Integrate TM1 cubes within a Cognos 8 Business Intelligence (BI) environment
• Integrate IBM Cognos TM1 in Cognos 8 BI portal
• Importing Cognos Tm1 Cube into Cognos 8 Bi Environment

Cognos 10 Course Curriculum

Cognos Architecture

Cognos 10 new features

Cognos Report 8 vs. Cognos 10

Cognos 10 Query Studio

• Creation Of List Report
• Converting List to Crosstab
• Converting List to Chart
• Interface Formatting
• Data Formatting
• Creation of Calculated Column
• Grouping
• Sorting
• Sectioning
• Creation of Custom Group
• Report Definition
• Conditional Formatting
• Filter
• Filter grouping
• Prompts
• Page brakes
• Suppress null values
• Run and Manage Reports
• Apply template to Query studio report
• Drill down and drill up
• How to apply Drill through

Event Studio

• How to create event
• How to add task
• How to run report when event condition satisfied
• How to run job when event condition satisfied
• How to send report out put to users through mail
• How to change task order
• How to schedule agent
• Cognos 10 Report Studio
• Introduction to Report tudio
• Report Studio User Interface
• Creating, Save and Run Reports
• Report Templates
• Managing Reports
• Types of Reports
• List Reports
• Crosstab Reports
• Charts
• Active form report
• Formatting a Report
• Report Layout Guidelines
• Fonts, Styles, Header, Footer and Borders
• Insert objects
• Apply Table Styles
• Swap Columns and Rows
• Working with Data
• Filters, Parameters and Prompts
• Detail Filter & Summary Filter
• Context filter
• Context prompt
• Slicer
• Creation of single select prompt
• Converting single select prompt to multi select prompt
• Creation of single select cascading prompt
• Creation of multi select cascading prompt
• Context filter and context prompt
• Sorting and Grouping
• Subtotals and Calculations
• Working with Queries
• Working with Reports
• Conditional Formatting
• Conditional style
• Style variables
• Render variable
• Drill-through Reports
• Master-Detail Reports
• Scheduling Reports
• Single report deployment
• Creation Of different type of variable
• How to apply Page brakes in Report Studio
• How to apply page brakes using context
• Creation of Query sets
• Report Template
• How to create Report Template
• How to apply RS Template to Qs report and Rs Report
• How to convert Report to Template

Manage External Data

Active Report

• How to convert report to active report
• How to use data tab control
• How to use tab control
• How to use button bar
• How to use data button bar
• How to use toggle button bar
• How to use toggle data button bar
• How to use data radio button group
• How to use data check box group
• How to use data drop down list
• How to use data list box
• How to convert control
• How to change active report properties

Analysis Studio

• About Analysis studio
• Creation Crosstab
• Nested Crosstab Creation
• How to create Context filter
• Add Filter on Rows and columns
• How to create combined filter
• How to display excluded item total in report
• Create Calculated Column
• How to change Column name
• Create Custom set
• Reuse Custom Set
• Swap rows and columns
• Create Chart
• Drill Down and drill up
• Drill through
• Top and bottom filter
• How to add totals and sub totals to crosstab
• Context filter
• How to add header to report
• How to apply page brakes
• How to apply template
• Drill down and drill up
• Drill through
• How to display cube updated date in header

Cognos 10 Framework Manager

• Creation of Project
• Creation of data source connection
• Data source connection to Database
• Data source connection to excel
• Data source connection to Cognos Power play
• Data source connection to Cognos TM1 Cube
• Import data From Database
• Native metadata
• Creation of Namespace, Folder ,Short cut to the Query subject
• Joins and cardinality

Query subjects

• Data source query subject
• Model query subject
• Stored procedure Query subject

Calculation

• Embedded calculation
• Standalone calculation

Filters

• Embedded Filters
• Standalone Filters

Query Set

• Changing Query usage item properties
• Regular Dimensions
• Measures Dimensions
• Scope Defining
• How to change usage property for Query item

Securities

• Objective level Securities
• Data Level Securities
• Package level Securities

Model Report

• Edit Governors
• Update Query subject
• Merge Query Subject
• Creation Of package
• Creation of nested Package
• Package versions
• Publishing package
• How to publish Package into Desktop
• How to change Contents in package
• Report Dependence
• View Transition history
• Run script
• Function Set
• How to publish more then one cube in one package
• Copy of Query subject and short cut of query subject
• Difference between folder and namespace

Cognos 10 Connection

• Examine Cognos Connection
• Creation of data Source connection at Cognos connection level
• Creation Of Report Shortcut
• Creation of Jobs
• Scheduling Reports, Report shortcut, Jobs
• Disabling Schedule
• Organize content with folders and shortcuts
• Personalize Cognos Connection
• How to add portal tab
• How to add report to portal tab
• Connecting Report to Another Package
• Create Users Groups and Users Roles
• Adding Users to Users Groups
• Importing and Exporting Reports From one Environment to Another
• Environment (Development Environment to production Environment )
• Publishing native metadata into Content store
• How to copy reports from one persons my folder to another persons my folder
• Drill through definition
• How to hide objects in cognos connection
• How to view hidden object in cognos connectionmy preferences
• How to change my preferences

Working with Cognos 10 My Inbox

• Creation of new tasks
• Creation of new notifications
• How to Change Owner
• How to add comments
• View comments User comments
• Audit comments
• Complete Task
• How to change Status of a task
• How to Change Priority of a task
• Cancel Task s
• How to archive a Task

My Dashboard

• About Tool
• Create New Dashboard
• Add Report to dashboard
• Creation of Select Value Filter
• Creation Of Slider Filter
• Insert Text into Dashboard
• How to insert My inbox into Dash Board
• How to Edit Dashboard Style
• How to edit source report from Dashboard
• How to Convert List to crosstab or chart
• How to change colures for Items in Chart

My Business Insight Advance

• How to create report using my business insight advance
• How to apply calculations
• Round
• Round up
• Absolute
• Round down
• How to pick first character from item
• How to pick last character from item
• How to find difference %
• How To Format Column
• How to create calculated columns
• How to apply Filters
• How to add context filter
• How to apply page brake using context
• How to apply conditional style
• How to add context filter
• How use page layer
• How to add prompt

Cognos 8 Course Curriculum

Cognos Architecture

Cognos Report net vs. Cognos 8

Cognos 8 Connection

• Creation of data Source connection at Cognos connection level
• Examine Cognos Connection
• Creation Of Report Shortcut
• Creation of Jobs
• Scheduling Reports,Report shortcut,Jobs
• Disabling Schedule
• Organize content with folders and shortcuts
• Personalize Cognos Connection
• Connecting Report to Another Package
• Adding Users to Users Groups
• Importing and Exporting Reports From one Environment to Another
• Environment (Development Environment to production Environment )
• Publishing native metadata into Content store

Cognos 8 Query Studio

• Creation Of List Report
• Converting List to Crosstab
• Converting List to Chart
• Interface Formatting
• Data Formatting
• Creation of Calculated Column
• Grouping
• Sorting
• Sectioning
• Creation of Custom Group
• Report Definition
• Conditional Formatting
• Filter
• Filter grouping
• Prompts
• Page brakes
• Editing title area
• Suppress null values
• Run and Manage Reports

Cognos 8 Report Studio

• 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
• Apply Table Styles
• Swap Columns and Rows
• Create and Modify Classes

Working with Data

• Filters, Parameters and Prompts
• Value Prompt, Taxt box prompt,Time prompt,date prompt,Date and
• time prompt
• Sorting and Grouping
• Subtotals and Calculations
• Working with Queries

Working with Reports

• Conditional Formatting
• Drill-through Reports
• Master-Detail Reports
• Scheduling Reports
• Creation Of different type of variable
• Creation of single select prompt
• Converting single select prompt to multi select prompt
• Creation of single select cascading prompt
• Creation of multi select cascading prompt
• Creation of Query sets
• Creation of Project
• Creation of data source connection
• Import data From Database
• Native metadata
• Creation of Namespace, Folder ,Short cut to the Query subject
• Joins and cardinality

Query subjects

• Data source query subject
• Model query subject
• Stored procedure Query subject

Calculation

• Embedded calculation
• Standalone calculation

Filters

• Embedded Filters
• Standalone Filters
• Query Set
• Changing Query item properties
• Regular Dimensions
• Measures Dimensions
• Scope Defining

Securities

• Objective level Securities
• Data Level Securities
• Package level Securities
• Model Report
• Edit Governors
• Update Query subject
• Merge Query Subject
• Creation Of package
• Creation of nested Package
• Package versions
• Publishing package
• How to change Contents in package
• Report Dependence
• View Transition history
• Run script