Course Content

• INTRODUCTION TO IBM COGNOS TM1
  • 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 CONFIGARATION 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
  • OBJECTIVES
  • 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
• 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