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