Duration
5 days
Overview
This is the self paced training version of ''IBM Cognos TM1 9.4: Designing and Developing Applications'' classroom course. IBM Cognos TM1 9.4: Designing and Developing Applications is a five-day, self paced course designed to teach application developers, typically business or financial people, how to set up a complete TM1 application. Through a series of lectures and hands-on exercises, students will learn how to set up and verify structures, manually enter data into these structures, and define the data users can see.
Audience
This advanced course is for Application Developers.
Prerequisites
You should have:
- Basic knowledge of OLAP and TM1
- Significant experience with Excel spreadsheets (functions, macros, etc.)
- Understanding of the metrics and drivers of you business
- IBM Cognos TM1 9.4: Analyzing Data (recommended)
Key topics
Introduction to IBM Cognos TM1
- Review financial performance management
- Discuss Online Analytical Processing (OLAP)
- Identify the TM1 position in the financial performance management system
- Describe the architecture and components of TM1
- Identify the basic tasks required to create a TM1 application and deploy it
Create Dimensions
- Review cubes and dimensions
- Create dimensions manually
- Edit dimensions
- Create dimensions using Turbo Integrator
Build Cubes and Views
- Discuss cubes and data points
- Create cubes
- Construct views of data in cubes
Load and Maintain 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
Add Business Rules
- Discuss a rule
- Construct rules for elements or consolidations
- Use functions in rules
- Optimize rule performance
- Discuss rules in a Rule Worksheet
Automate Common Processes Using Scripts
- Review Advanced tabs in Turbo Integrator
- Load custom data into a cube
- Add a subset to a dimension
- Use logic in scripts
- Export data to ASCII
- Move data between versions
- Construct chores
Customize Drill Paths
- View related data
- Create a Drill Process
- Create a Drill Assignment Rule
- Edit a drill process
Using Rules for Advanced Modeling
- Discuss virtual cubes
- List uses for lookup cubes
- Create and use a spread profile cube
- Implement moving balances in a cube
Convert Currencies
- Discuss currency challenges
- Create currency dimension
- Create currency cube
- Create rules for currency conversion
- Use TM1 techniques to reduce maintenance
Model for Different Fiscal Requirements
- Discuss time considerations
- Use discrete time dimensions
- Implement a continuous time dimension model
Present Data and Reports
- Organize content in TM1 using application folders
- Use Action buttons to enhance functionality in Excel and TM1 Web reports
- Add worksheet controls to change the presentation of data
Define Workflow
- Configure TM1 for Workflow
- Install Workflow
- Create Workflow versions
- Use Workflow toolbars to review versions
A: Introduction to Executive Viewer
- Repeat the steps to start the TM1 server and start the Executive Viewer client to employ Executive Viewer functionality
- Locate data by connecting to a data source
- Create a view to analyze your data
- Organize members and dimensions within a view
B: Integrate with IBM Cognos 8 BI and IBM Cognos 8 Planning
- Integrate TM1 cubes within a Cognos 8 Business Intelligence (BI) environment
- Integrate IBM Cognos TM1 in Cognos 8 BI portals
- Describe how to use TM1 data in an IBM Cognos 8 Planning application
- Describe how to use IBM Cognos 8 Planning data in a TM1 application
This is a version-specific reference outline. Confirm the current syllabus and delivery arrangements with EIEIO.