Základní info
IBM Cognos TM1: Design and Develop Models (V9.5) is a five-day, instructor-led course designed to teach modelers how to build a complete model in TM1. 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.
Dostupnost tohoto kurzu v zahraničí
Kurz je určen pro:
This intermediate course is intended for Modelers
Předpokládané znalosti:
You should have taken:
- IBM Cognos TM1: Analyze Data (V9.5)
You should have:
- Basic knowledge of OLAP and TM1
- Significant experience with Excel spreadsheets (functions, macros, etc.)
- Understanding of the metrics and drivers of your business
Obsah:
Introduction to IBM Cognos TM1
- Review financial performance management
- Describe the architecture and components of TM1
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
- Create and use a pick list
Load and Maintain Data
- Create processes to load data
- Create a process to delete data in a cube
- Create processes to update 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
Optimize Rule Performance
- Optimize rule performance
- Use Skipcheck and Feeders
- Employ tools to enhance rules and feeders
Transfer Data into Your Model Using Scripts
- Review Advanced tabs in Turbo Integrator
- Add a subset to a dimension
- Use logic in scripts
- Move data between versions
- Construct chores
Customize Drill Paths
- Create a Drill Process
- Create a Drill Assignment Rule
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
Model for Different Fiscal Requirements
- Discuss time considerations
- Use discrete time dimensions
- Implement a continuous time dimension model
Introduction to Managed Planning Applications
- Review the purposes and benefits of a managed planning application
- Review supported platforms
Contribute Data to Managed Planning Applications
- Access a Managed Planning Applications
- Identify user roles and workflow states
- Enter data using shortcuts and spreading
- Submit and reject data
Create and Deploy Planning Applications to the Web
- Create a Managed Planning Application
- Apply security to Managed Planning Applications
- Examine design techniques and best practices
- Define Workflow (Optional)
- Integrate with IBM Cognos 8 BI and IBM Cognos Planning (Optional)
- Design for Reporting (Optional)
- Optimize and Tune TM1 Models (Optional)
- Identify Common Data Structures (Optional)
