Overview of IBM Cognos TM1

• review financial performance management
• identify the TM1 position in a performance management system
• describe the IBM Cognos TM1 components and architecture
• explore IBM Cognos TM1 applications
• explore the IBM Cognos TM1 environment
• manage and organize a model

Create and Customise Dimensions

• review cubes, dimensions, and elements
• create dimensions manually
• import dimensions
• edit dimensions
• create dimension calculations
• use Guided Import to create a dimension

Create and Customise Cubes

• construct a new cube
• discuss cube properties
• edit a cube structure
• review and use a pick list
• create cube calculations

Import Data

• identify data sources
• create processes to load data
• create a process to delete data in a cube
• create processes to update and maintain the model

Share Data Across Cubes with Links

• discuss and list types of links
• create and modify links
• review rule- and process-based links

Complete the Income Statement Model

• discuss the model development process
• complete objects for the model
• review tools to aid in model development

Create Applications

• explain the application types
• access an IBM Cognos TM1 application
• create a new application
• set the available clients
• apply security in the application
• activate and de-activate an application

Additional Modeling Techniques

• create dynamic subsets
• use dimension functions
• implement business logic
• improve cube performance
• use TM1 utilities

Convert Currencies

• discuss currency challenges
• review control cubes
• create rules for currency conversion
• use TM1 techniques to reduce maintenance

Model Data with Architect

• describe IBM Cognos TM1 Architect
• record MDX queries
• customise drill-through paths

Model for Different Fiscal Requirements

• discuss time considerations
• use discrete-time dimensions
• implement a continuous-time dimension model

Optional Modules

• Contribute to Planning Applications
• Integrate with IBM Cognos BI
• Administer IBM Cognos Insight
• Additional Workshop
• Optimize and Tune Models
• Identify Common Data Structures
• Customise Business Rules
• Optimize Rule Performance

• Basic knowledge of OLAP and TM1
• Significant experience with Excel spreadsheets (functions, macros, etc.)
• Understanding the metrics and drivers of your business

It is recommended that you complete course IBM Cognos TM1: Interact with Data (V10.2) WBT.