30 Hours(For Regular Course)

4-8 Hours(For Capsule Course)

Enroll Now

Request more information


This web-based training course on IBM COGNOS Training functionality, administration and development, is available online to all individuals, institutions, corporates and enterprises in India (New Delhi NCR, Bangalore, Chennai, Kolkatta), US, UK, Canada, Australia, Singapore, United Arab Emirates (UAE), China and South Africa. No matter where you are located, you can enroll for any training with us - because all our training sessions are delivered online by live instructors using interactive, intensive learning methods.

COGNOS, an acquisition of IBM is a performance management and Business Intelligence suite that is designed to allow business users without much technical know-how to dig out corporate data, analyze the same and then create reports. A combination of more than over 30 software products, the software suite supports the use of relational and multidimensional data sources from various providers. The IBM COGNOS suite provides a set of various functionalities that help the organization get a better view of their data and eventually analyze it and move further. IBM COGNOS Business Intelligence 11.0.4 is the latest version of the suite and the other popular versions are IBM COGNOS Business Intelligence 10.2.2 and IBM COGNOS Busness Intelligence 10.1.1.

Overview of IBM COGNOS

  • Objectives
  • Review the ibm cognos solution
  • Financial performance management
  • Ibm cognos tm1 10.1 solution
  • Ibm cognos tm1 architecture
  • Ibm cognos web architecture
  • Ibm cognos tm1 applications architecture
  • Ibm cognos insight
  • Demo 1: navigate and explore data in ibm cognos insight
  • Benefits of ibm cognos performance modeler
  • Cognos tm1 performance modeler actions
  • Cognos tm1 performance modeler window
  • Create folders to organize the model
  • Ibm cognos performance modeler
  • Object icons
  • Demo 2: explore ibm cognos tm1 performance modeler
  • Configure an ibm cognos tm1 server
  • Demo 3: create a new server and manage the model

Identify common data structures

  • Examine the role of an ibm cognos tm1 metadata model
  • Distinguish between operational and reporting databases
  • Identify features of an operational database
  • Identify issues with operational databases
  • Examine reporting databases (star schema design)
  • Create a star schema
  • Examine operational data
  • Examine reporting data
  • Examine fact tables
  • Examine dimension tables
  • Identify issues with a star schema
  • What is olap?
  • Olap vs. Oltp (relational)
  • Dimensional analysis example
  • Examine olap data structures
  • The three core design principles
  • Create a model in ibm cognos tm1
  • Demo 1: review files to use as data sources

Import data to create objects

  • View the model
  • Create objects with guided import
  • Import a dimension
  • Select data source
  • Map the data
  • Add expressions
  • Demo 1: use guided import to create a dimension
  • Use guided import to build a cube
  • Steps to import a cube
  • Map data to a cube
  • Demo 2: use guided import to create a cube

Create and customize dimensions

  • What is a dimension?
  • What is an element?
  • Name considerations for dimensions
  • Create new dimensions
  • Review dimension types
  • Calculation dimension
  • Calculation dimension attributes
  • Version dimension
  • Demo 1: create and review new dimensions
  • Time dimension attributes
  • Populate the time dimension tool
  • Demo 2: create a time dimension
  • Additional dimension types
  • Import data for a dimension
  • Demo 3: import data into a hierarchy dimension
  • Assign weights to elements
  • Review attributes
  • Create subsets for dimensions
  • Demo 4: create attributes and subsets
  • Add a calculation to a member
  • Demo 5: create dimension calculations

Create and customize cubes

  • View the model
  • Construct a cube
  • Discuss dimension order in a cube
  • Create a cube
  • Create a view
  • Demo 1: create cubes and views
  • Edit the cube structure
  • Demo 2: edit the structure of a cube
  • Use the pick list attribute
  • Demo 3: create and use a pick list

Import data

  • Use processes to load and maintain data
  • List steps to create a new process
  • Determine the data source
  • Review the data structure
  • Load data into an existing cube
  • Demo 1: load data to a cube
  • Demo 2: load data to a cube using functions
  • Use processes to maintain the model
  • Demo 3: create a process to delete data in a cube
  • Demo 4: create a process to save data in a cube

Share data across cubes with links

  • What are links?
  • Use the link editor
  • Review correspondence
  • Select automatic map option
  • Discuss manual map options
  • Review unmapped dimensions
  • Change the correspondence
  • How will a link manifest itself?
  • Demo 1: establish a link between two cubes
  • Review lookup and accumulation links
  • Review lookup links in detail
  • Review accumulation links in detail
  • Create links with attributes
  • Use a link manifested as a process
  • Create an internal link
  • Demo 2: create a lookup link

Customize business rules

  • View the model
  • Add business logic
  • Use manual vs. Automatic rules
  • Create a rule manually
  • Use a modifier in a rule
  • Automatic generation of rules
  • Identify an auto-generated rule
  • Review rule processing order
  • Discuss rule sequence
  • Drag and drop rule blocks
  • Enable and disable rules
  • Add rules manually
  • Demo 1: review and modify automatically generated rules
  • Use a function in a rule
  • Write string rules
  • Demo 2: use functions in rules
  • Use weights in calculations
  • Demo 3: create calculations with hierarchy and weight
  • Determine location of logic

Optimize rule performance

  • Discuss consolidations and sparsity
  • Review the effect of rules on consolidations
  • Optimize rules with skipcheck
  • Discuss skipcheck with consolidations
  • Use feeders in a rule file
  • Discuss a feeder statement
  • Examine feeder statements
  • Review inter-cube feeders
  • Feed string rules
  • Demo 1: review and adjust feeders

Complete the income statement model

  • View the model
  • Discuss model design
  • Review the data
  • Use model design utilities
  • Complete the income statement model
  • Demo 1: create the expenses cube
  • Demo 2: create the income statement accounts dimension

Create applications

  • Access an ibm cognos tm1 application
  • What is an application?
  • Examine the administrator role
  • Examine application types
  • Examine clients and connection modes
  • Examine the contributor role
  • Examine the reviewer role
  • Identify workflow states
  • Demo 1: examine three types of applications
  • Review application design
  • Describe approval applications
  • Discuss responsibility applications
  • Review central applications
  • Define an application
  • Select views for the application
  • Define an approval hierarchy
  • Select the default clients
  • Validate the application
  • Deploy an application
  • Grant object access
  • Set security in an application
  • Use the portal to manage applications
  • Demo 2: create and deploy an approval application
  • Use advanced modeling

Additional modeling techniques

  • View the model
  • Use dynamic subsets
  • List of dynamic subset selection
  • Demo 1: create a dynamic subset
  • Review dimension functions
  • Describe calculation dimension functions
  • List version functions
  • Use conditional logic in functions
  • Review additional rule functions
  • Demo 2: add cumulative totals to commissions
  • Demo 3: create the customer_churn cube
  • Use the cube optimizer

Convert currencies

  • Implement currency conversion
  • Review control cubes
  • Create custom rules
  • Demo 1: add currency conversion to the expense cube

Model data with ibm cognos tm1 architect

  • Review ibm cognos tm1 architect
  • Model data with tm1 architect
  • Demo 1: create a cube in ibm cognos tm1 architect
  • Use additional tools
  • Debug rules
  • Trace feeders
  • Demo 2: record an mdx expression in tm1 architect
  • Apply drill-through
  • Create a drill process
  • Create a drill assignment rule
  • Demo 3: create a drill-through path to a view in Another cube

Model for different fiscal requirements

  • View the model
  • Discuss time in olap
  • Examine discrete time dimensions
  • Demo 1: add a year dimension
  • Continuous time dimensions
  • Develop continuous time model
  • Demo 2: create a continuous time model

The IBM COGNOS promises of faster results with lower costs, making it the favorite platform for all the big and relatively small organizations. Undoubtedly IBM COGNOS is a pioneer in the field of Business Intelligence. With every passing day, the significance of this performance management and Business Intelligence is increasing and the updated versions are adding more to its vitality. The future scope for IBM COGNOS seems to be very bright keeping in mind the advantage it provides businesses in analyzing and extracting corporate data. Going by the current scenarios, the future for individual professionals in the field is even brighter.

1. Are lab-sessions available after theory sessions?

We provide online lab facilities to all our students, wherever possible & applicable, using a combination of one or more options, including global ASP setups, live-environments, real-time simulations, training-videos, PPTs, Screenshots and others.

2. Who and how qualified are the instructors?

All our instructors go through a rigorous and multiple processes of filtering and selection before they are appointed by us. Only the most qualified, most experienced and best suited candidates are chosen as instructors.

3.What are the machine requirements for the course?

You must have a fairly good desktop PC or laptop. You can even access these courses on your tabs or smart phones. For PCs and laptops the configuration should be at-least an Intel Pentium processor, 4GB of RAM and 50 to 100 GB of free hard disk space. You must also have a good and steady WiFi internet connection which works at 3G or 4G speeds.

4.How will I undergo practical training in the course?

Depending on the type of lab facilities available for the course you have enrolled in for our instructor would be happy to help you in your lab sessions.

5.What is the process to get my questions/queries answered?

Get in touch with your trainer. You can also consult your batch-mates. We believe in collaborative and practical learning.

6.Can a free demo session be provided?

We do not provide free demo sessions.

7.Will there be a provision for repetition if I miss a class?

We encourage our trainees to attend all sessions. If you have missed a session we will try out best to update you on it, if possible. Else you will need to pay a small fee to have a repeat session arranged specifically for you.

8.Does your organization provide assistance in job hunting?

We are connected across the industry in India and abroad. We will pass on any job openings from our customer to our trainees. But we are not a manpower placement provider.

9.How and where can I make the payment?

You can pay using any credit or debit card in India or abroad. You can also pay using your PayPal account.

10. Will practice material or tests be also provided with the course?

Yes. As required & as applicable.

11.What is the minimum or maximum batch size?

Minimum/maximum batch sizes vary from course to course, depending upon a number of factors. It can vary from as few as 2 to as many as a few hundred, in some cases. But that number does not impact the quality of training that we deliver due to our tight quality-control mechanisms.

All trainees will be provided with a course participation and completion certificate by Aurelius Corporate Solutions. Please note, we are an independent provider of learning solutions. We are not affiliated in any manner to any company or organization.

Copyright © 2016 Aurelius Corporate Solutions Pvt. Ltd. All Rights Reserved.