INTRODUCTION TO IBM COGNOS TM1

Who can learn this course:

Individuals who want to become Cognos Tm1 specialist, consultants and developers

Pre Requisite:

  • Students must have basic knowledge on OLAP and Significant experience with Excel spreadsheets (functions, macros, etc.) and Understanding of the metrics and drivers business.

End Objective:

  • Cognos TM1 enables planners and analysts to uncover hidden business options, increase profits and manage capital effectively.
  • It provides an on-demand approach to consolidating, viewing, and editing enormous volumes of multidimensional data.

Course Duration: 45 Hours

Course Content :

  • THE IBM COGNOS SOLUTION
  • FINANCIAL PERFORMANCE MANAGEMENT
  • WHAT IS OLAP
  • OLAP VS. OLTP (RELATIONAL)
  • DIMENSIONAL ANALYSIS EXAMPLE
  • EXAMINE OLAP DATA STRUCTURES
  • TM1 OLAP SOLUTION
  • USE DIFFERENT TM1 USER INTERFACES
  • EXAMINE TM1 USERS
  • EXAMINE TM1 TECHNOLOGY
  • Installation and Configuration of TM1
  • IMPORTANT FILES IN TM1
  • CREATE A NEW TM1 SERVER
  • CREATE AN APPLICATION IN TM1

CREATE DIMENSIONS

  • OBJECTIVES
  • WHAT IS A DIMENSION
  • WHAT IS AN ELEMENT?
  • USING WEIGHTS WITH ELEMENTS
  • USING ATTRIBUTES
  • CREATE DIMENSIONS
  • MANUALLY
  • MODIFY EXISTING DIMENSIONS
  • WHAT IS TURBO INTEGRATOR
  • CREATE A DIMENSION USING TURBO INTEGRATOR

BUILD CUBES AND VIEWS

  • OBJECTIVES
  • STORE DATA IN CUBES
  • BUILD CUBE
  • CONSIDER DIMENSION ORDER
  • NAME THE CUBE
  • CREATE A VIEW

LOAD AND MAINTAIN DATA

  • OBJECTIVES
  • DETERMINE THE DATA SOURCE
  • REVIEW THE DATA STRUCTURE
  • LOAD DATA WITH TURBO INTEGRATOR
  • IMPORT DATA FROM AN ASCII FILE
  • USING FORMULAS IN VARIABLES
  • IMPORT DATA FROM AN ODBC SOURCE
  • USE TURBO INTEGRATOR TO MAINTAIN THE MODEL
  • CLEAR DATA FROMA CUBE USING A PROCESS

ADD BUSINESS RULES

  • ADD BUSINESS LOGIC
  • CREATE A RULE
  • USE A FUNCTION IN A RULE
  • OPTIMIZE YOUR RULES
  • USING FEEDER STATEMENTS
  • ADD SKIPCHECK AND FEEDERS

AUTOMATE COMMON PROCESSES USING SCRIPTS

  • REVIEW SCRIPTING WITH TURBO INTEGRATOR
  • BENEFITS OF CUSTOM SCRIPTS
  • USE TM1 AS A DATA SOURCE
  • INTEGRATOR
  • USE CHORES WITH TURBO INTEGRATOR

CUSTOMIZE DRILL PATHS

  • VIEW RELATED DATA
  • CREATE A DRILL PATH
  • CREATE A DRILL-THROUGH PATH TO A VIEW IN ANOTHER CUBE
  • CREATE A DRILL PATH TO AN ODBC SOURCE

PRESENT DATA AND REPORTS

  • OBJECTIVES
  • ORGANIZE CONTENT IN A TM1 APPLICATION
  • USING APPLICATION FOLDERS:
  • ADD TM1 OBJECTS AND EXTERNAL FILES TO AN APPLICATION
  • BUILD WORKSHEETS WITH ACTION BUTTONS
  • ADD AN ACTION BUTTON TO A WORKSHEET
  • USE WORKSHEET CONTROLS TO PRESENT DATA
  • USE CONTROLS FOR DATA VALIDATION
  • USE TOOLBARS TO ADD CONTROLS
  • ADD A DATA VALIDATION CONTROL TO A MICROSOFT EXCEL SPREADSHEET
  • FORMAT REPORTS
  • CHANGE THE FORMATTING ON A REPORT AND CREATE A CUSTOM MENU

REPLICATE AND SYNCHRONIZE SERVERS

Ø REPLICATE A TM1 CUBE

Ø REMOVE REPLICATIONS

Ø SYNCHRONIZE REPLICATIONS

EXAMINE THE ADMIN SERVER LOG

EXAMINE THE TRANSACTION LOG

EXAMINE THE SERVER MESSAGE LOG

BACKUP AND RECOVER APPLICATIONS

DEFINE WORKFLOW

  • CONFIGURE TM1 FOR WORKFLOW
  • REVIEW TM1 SECURITY
  • ADD USERS AND GROUPS TO TM1 SECURITY
  • INSTALL WORKFLOW
  • CREATE A WORKFLOW PROCESS

INTEGRATE WITH IBM COGNOS 8 BI

  • BENEFITS OF IBM COGNOS 8 INTEGRATION
  • INTEGRATE IBM COGNOS TM1 WITH IBM COGNOS 8 BI
  • CREATE A PORTLET WITH TM1 WEB

INTRODUCTION TO EXECUTIVE VIEWER

  • EXPLORE EXECUTIVE VIEWER
  • EXPLORE THE EXECUTIVE VIEWER CLIENT INTERFACE
  • CREATE A VIEW AND CONNECT TO A DATA SOURCE
  • EXAMINE A CUBE
  • EXAMINE VIEWS
  • FOCUS ON SPECIFIC DATA
  • SELECT AND ARRANGE MEMBERS
  • DRAG AND DROP, STACK, AND HIDE DIMENSIONS