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