COGNOS TM1 COURSE CONTENT

INTRODUCTION TO DATAWARE HOUSING (DWH)

• Describe IBM Cognos Business Intelligence (BI) and Financial Performance Management (FPM)
• Introduction to DWH
• Characteristics of DWH
• OLTP Vs OLAP Databases
• Different Approaches of DWH (Kimball Vs Inmon)
• Data mart Vs Data Warehouse
• Fact Table Vs Dimension Table
• Types Of Facts
• Types Of Dimensions
• ETL
• Staging Area
• Concepts of Schemas (Star schema & Snowflake schema)
• Surrogate Key
• Slowly Changing Dimension Types
• Industry leading ETL and Reporting tools

INTRODUCTION TO COGNOS

• About Cognos 10.1
• 3 – Tier Cognos 10.1 Architecture
• Cognos Release (EP series7, Reportnet , Cognos 8.0/8.1/8.2/8.3) and their differences
• New Features of Cognos 10.1
• Cognos Vs other OLAP tools
• Cognos components (Modeling & Reporting)
• Different cognos services

IBM COGNOS BI ARCHITECTURE

Identify features of the IBM Cognos BI architecture

Explain the Dispatcher and Cognos BI servlets and services

Identify an example of Cognos BI request processing

Examine the Cognos Application Firewall

Content Manager and Content Store

Perform a distributed installation and configuration of IBM Cognos BI

COGNOS CONNECTIONS

• Personalize Cognos Connection
• Create and manage portals, shortcuts, report views..etc
• Running the Report Burn
• Various Options in Cognos Connection
• Working with Cognos configuration, content Store
• How to Connect to different Data Sources
• Security setup
• Properties of an Entry
• Search for an Entry
• Bookmark an Entry

• Import and Export of Package (Deployment)
• Scheduling and manage reports
• Create Jobs
• Cognos groups and roles
• Cognos Business Insight Advanced

QUERY STUDIO

• Introduction
• Features in Query Studio
• About Ad-hoc Reports
• Types of Report(List, Cross Tab, Chart Reports & Others)
• Applying Filters, Prompts & Calculations
• Sorting, Grouping, Sections & Aggregate Functions
• Apply page break on Reports
• Run and Manage reports

· Define custom group

· Conditional formatting

· Expand and Collapse groups

· Apply Swap and Rows on Reports

REPORT STUDIO

• Report Studio User Interface
• Creating, Save and run reports
• Managing Reports.
• Creating list, Cross Tab, Chart, repeater, Maps & Other Reports
• Group and section on List report having 1:M relationship
• Group span on List report having 1:1 relationship
• Apply page break on reports.
• Headers and Footers on Crosstab report
• Report templates, formatting Reports – fonts, style, header, footer, boarder…etc
• Filters, Parameters and Prompts
• Subtotals and Calculations
• Working with Queries
• Generating and Creating Prompt Page
• Format Data
• Map Report,Repeater objects
• Types of Prompts
• Types of Variables
• Layout Component Reference to reuse the objects
• Building the Cube Reports
• Building the Dashboard Reports
• Query Calculations & Layout Calculations
• Filters and Dynamic Filters
• Conditional Block
• Conditional Formatting
• Master Details Relationship reports
• Cascading Prompt
• Set Operators
• Setting Burst Options
• Drill through reports
• HTML Items & Hyperlinks
• Drill up & Drill down
• Setting Variables
• Report Functions
• Report Validation
• Bookmark
• Bursting
• Reports Run with Options
• Different types of Reports with various functionalities
• Unions
• Joins
• Components and there properties.

ANALYSIS STUDIO

• Insert Data
• Change the number of Visible Items
• Analyze data using Analysis Studio
• Nest Data
• Replace Data
• Sort Data
• Explore Data
• Change the measure
• Drill up & Drill down on reports
• Drill down for Details
• Hide Items
• Insert a calculation
• Save a custom set
• Define a filter
• Compare sets of data
• Using Dynamic Context

EVENT STUDIO

• Creating Agents
• Adding Event conditions
• Task and Task execution rules
• Scheduling Agents

METRIC STUDIO

• Identify scorecards, metrics, and metric types
• Organize metrics with strategies
• Track initiatives with projects
• View metric history
• Address problems with actions
• Monitor status visually with diagrams
• Verify metric details
• Quickly access important metrics
• Create a scorecard
• Create metrics
• Enter metric values
• Customize Metric Studio
• Report on Metric Studio data

FRAMEWORK MANAGER

• About Framework Manager
• Framework Manager, Metadata Modeling
• Creation of Interface and Usage
• Create a Project

· Creating the data source connection

• Creating Model & Namespace (Layers)
• Importing Metadata

· Work with dimensions and Modify properties of Query Items

· Naming convention for objects in a project

• Creating Query Subjects & Query Items
• Merging Query Subjects
• Creating Relationships & Setting Cardinalities
• Creating Parameter Maps & Macros
• Creating of Model Filters, Prompts & Calculations
• Parameter Map
• Loop
• Usage property, regular aggregate properties
• Add Business Rules and Set Governors
• Assigning package level security,Object Level security and Data Level security
• Improving performance
• Describe Transformer capabilities and its role in IBM Cognos BI
• Describe Transformer components
• Organize the model
• Publishing Package

DASHBOARDS in IBM Cognos BI

• Describe IBM Cognos Business Insight
• Explore navigation and general functionality
• Create a dashboard from existing content
• Modify an existing dashboard
• Collaborate on a dashboard

Extend IBM Cognos BI

• Describe IBM Cognos Go Mobile
• Explain IBM Cognos for Microsoft Office

INTRODUCTION TO POWERPLAY TRANSFORMER CUBES

· Cognos 10 Cube Creation using Transformer

· Different aspects of cognos cube

· Levels, categories, dimension and measures in Transformer

· Viewing the cube data in Powerplay reports

COGNOS BI ADMINISTRATION

· Describe the role of the Administrator in relation to the IBM Cognos BI administration workflow process

• Describe the role of IBM Cognos Administration and IBM Cognos Configuration user interface components
• Manage dispatchers and services
• Tune server performance
• Identify issues while troubleshooting the server environment
• Formulate the IBM Cognos BI backup strategy
• Configure IBM Cognos for Microsoft Office
• Manage user profiles

· Enable users to navigate to related data in IBM Cognos BI

COGNOS TM1

• Review financial performance management
• Describe the architecture and components of TM1

Create Dimensions

· Review cubes and dimensions

· Create dimensions manually

· Edit dimensions

· Create dimensions using Turbo Integrator

Build Cubes and Views

· Discuss cubes and data points

· Create cubes

· Construct views of data in cubes

· Create and use a pick list

Load and Maintain Data

· Create processes to load data

· Create a process to delete data in a cube

· Create processes to update the model

Add Business Rules

· Discuss a rule

· Construct rules for elements or consolidations

· Use functions in rules

· Optimize rule performance

· Discuss rules in a Rule Worksheet

Optimize Rule Performance

· Optimize rule performance

· Use Skipcheck and Feeders

· Employ tools to enhance rules and feeders

Transfer Data into Your Model Using Scripts

· Review Advanced tabs in Turbo Integrator

· Add a subset to a dimension

· Use logic in scripts

· Move data between versions

· Construct chores

Customize Drill Paths

· Create a Drill Process

· Create a Drill Assignment Rule

Using Rules for Advanced Modeling

· Discuss virtual cubes

· List uses for lookup cubes

· Create and use a spread profile cube

· Move data between versions

· Implement moving balances in a cube

Convert Currencies

· Discuss currency challenges

· Create currency dimension

· Create currency cube

· Create rules for currency conversion

Model for Different Fiscal Requirements

· Discuss time considerations

· Use discrete time dimensions

· Implement a continuous time dimension model

Introduction to Managed Planning Applications

· Review the purposes and benefits of a managed planning application

· Review supported platforms

Contribute Data to Managed Planning Applications

· Access a Managed Planning Applications

· Identify user roles and workflow states

· Enter data using shortcuts and spreading

· Submit and reject data